Synonyms

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Unknown Unknown » Synonyms

Synonyms

Rate Topic

Display Mode

Topic Options

Author

Message

Site Owners

Posted Tuesday, January 29, 2008 11:33 PM

SSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,040, Visits: 1

Comments posted to this topic are about the item Synonyms

Post #449189

Bob Griffin

Posted Wednesday, January 30, 2008 7:28 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, May 16, 2013 2:26 PM
Points: 1,132, Visits: 663

Here's a nice intro article on synonyms

http://www.developer.com/db/article.php/3613301

Post #449380

Jeff Deluca

Posted Wednesday, January 30, 2008 8:02 AM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, May 31, 2011 2:32 PM
Points: 491, Visits: 221

Thanks rgriffin. That article was quick and easy to read.

Post #449412

Yelena Varshal

Posted Wednesday, January 30, 2008 10:24 AM

Hall of Fame

Group: General Forum Members
Last Login: Monday, July 30, 2012 10:42 AM
Points: 3,434, Visits: 519

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

Jeff Deluca

Posted Wednesday, January 30, 2008 10:40 AM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, May 31, 2011 2:32 PM
Points: 491, Visits: 221

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

HardCoder

Posted Tuesday, February 12, 2008 11:06 PM

SSC 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

IgorMi

Posted Sunday, April 01, 2012 6:42 AM

SSCommitted

Group: General Forum Members
Last Login: Yesterday @ 4:19 PM
Points: 1,878, Visits: 1,446

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

Post #1276328

L' Eomot Inversé

Posted Sunday, April 01, 2012 3:13 PM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 5:48 PM
Points: 7,088, Visits: 7,143

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
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)

Post #1276418

« Prev Topic | Next Topic »

Permissions