Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Synonyms Expand / Collapse
Author
Message
Posted Tuesday, January 29, 2008 11:33 PM
SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, Visits: 1
Comments posted to this topic are about the item Synonyms
Post #449189
Posted Wednesday, January 30, 2008 7:28 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, July 7, 2014 10:01 AM
Points: 1,136, Visits: 697
Here's a nice intro article on synonyms

http://www.developer.com/db/article.php/3613301
Post #449380
Posted Wednesday, January 30, 2008 8:02 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, July 11, 2014 9:08 AM
Points: 491, Visits: 223
Thanks rgriffin. That article was quick and easy to read.
Post #449412
Posted Wednesday, January 30, 2008 10:24 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, August 8, 2014 1:35 PM
Points: 3,475, Visits: 580
My RTM BOL says:
The following table contains a list of these statements and expression contexts.
SELECT
INSERT
UPDATE
DELETE
EXECUTE
Sub-selects
DML and DDL statements that appear inside Dynamic SQL.1
1 Synonyms cannot be used with Full-Text DDL.

So it says that DDL can be used but not full-text one




Regards,
Yelena Varshal

Post #449538
Posted Wednesday, January 30, 2008 10:40 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, July 11, 2014 9:08 AM
Points: 491, Visits: 223
Yelena Varshal,
My coworker's BOL said the same thing that yours did.
My BOL did not say that. We checked our versions and his is
older than mine. My BOL page says:
Updated: 14 April 2006

at the top.
Maybe that's what they removed in the updated version?


PS
This is they BOL page we were both on just for comparison for anyone else.

BOL: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/c3d3f14f-4cc1-465c-89b6-0299f7e77bc0.htm

Online: http://msdn2.microsoft.com/en-us/library/ms190626.aspx
Post #449547
Posted Tuesday, February 12, 2008 11:06 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, October 18, 2011 12:57 AM
Points: 213, Visits: 97
I could not understand this question clearly.
May be someone please elaborate this.


Mohammad Irfan
http://matespoint.blogspot.com
http://www.irfit.com
Post #454870
Posted Sunday, April 1, 2012 6:42 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 5:16 AM
Points: 2,931, Visits: 2,949
--SQL 2012
CREATE TABLE [dbo].[test](
[i] [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](
[i] [int] NULL,
[j] [int] NULL
)

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

Regards





Igor Micev,
SQL Server developer at Seavus
www.seavus.com
Post #1276328
Posted Sunday, April 1, 2012 3:13 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 4:54 PM
Points: 8,689, Visits: 9,223
IgorMi (4/1/2012)
--SQL 2012
CREATE TABLE [dbo].[test](
[i] [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](
[i] [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
Post #1276418
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse