--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