• mw112009 (2/12/2016)


    Sean:

    Here you go:

    Whether it is accurate or not.. Your decision

    http://sqlindia.com/generate-table-definitions-using-tsql-sql-server/

    if this is the code you intend to use http://sqlindia.com/generate-table-definitions-using-tsql-sql-server/ then please see below

    CREATE TABLE [dbo].[TableTest](

    [inta] [int] NOT NULL,

    [intb] [int] NOT NULL,

    [calc] AS ([inta]+[intb]) PERSISTED

    )

    GO

    --OUTPUT from sp_helptable

    CREATE TABLE [dbo].[TableTest](

    [inta] [int] NOT NULL,

    [intb] [int] NOT NULL,

    [calc] [int] NULL

    )

    GO

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day