• --SQL 2012

    CREATE TABLE [dbo].[test](

    [int] NULL

    )

    CREATE SYNONYM [dbo].[testSinonim] FOR [mytestdb].[dbo].[test]

    GO

    Alter table test

    Add j int null

    --================

    After scripting the table, the result is following

    CREATE TABLE [dbo].[test](

    [int] NULL,

    [j] [int] NULL

    )

    I just want to say the question is not valid for upper versions of SQL 2005.

    Regards

    Igor Micev,My blog: www.igormicev.com