Post reply

Generate Create View statements for database tables.

  • August 15, 2013 at 11:01 pm

    #395313

    Comments posted to this topic are about the item Generate Create View statements for database tables.

    Wes
    (A solid design is always preferable to a creative workaround)

  • August 16, 2013 at 7:41 am

    #1642173

    Can you show us what the output will look like?

  • March 25, 2014 at 12:03 pm

    #1700012

    Here is the definition of the Employee table from the AdventureWorks db. The output is formatted as displayed.

    Create View [dbo].[Employee]

    AS

    ( SELECT [EmpID]

    , [NAME]

    , [Salary]

    FROM [AdventureWorks2008R2].[dbo].[Employee]

    )

    GO

    As written, it uses the 3 part naming from the source table and uses the table name as is for the view name, which will not be valid while the table has the same name. Change the view name portion to fit your naming convention. For example to prefix the table name with a "v", add the v to the string containing the dot between the schema and table name, as below.

    QUOTENAME(c1.TABLE_SCHEMA) + '.v' + QUOTENAME(c1.TABLE_NAME)

    Wes
    (A solid design is always preferable to a creative workaround)

  • April 28, 2016 at 7:16 am

    #1875237

    Thanks for the script.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply