IgorMi (4/1/2012)
--SQL 2012CREATE TABLE [dbo].[test](
[int] NULL
)
CREATE SYNONYM [dbo].[
] 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
The question isn't about
Alter table test
Add j int null
but about
Alter table testSinonim
Add j int null
It's about using the synonym, not about using the original table name.
Tom