Adding view to a schema

• uzwa ul haque

  SSChasing Mays

  Points: 607

  More actions

  April 19, 2007 at 4:09 am

  #172080

  Hi

  I want to add a few of my Views to a Schema and then Grant rights onto that schema... granting rights is no Issue but i cant figure out how to Create a new Schema and add an existing view in it.

  Help me out here guyz

• David Scotland-132255

  SSCertifiable

  Points: 5599

  More actions

  April 19, 2007 at 7:16 am

  #701420

   

  CREATE SCHEMA myviews with authorization dbo;

   

  CREATE VIEW dbo.nastyview

  AS .....

  ALTER schema myviews TRANSFER dbo.nastyview

  David