Identity Crisis: Attack of the Clone

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 dun » Identity Crisis: Attack of the Clone

36 posts, Page 4 of 4

«««1 2 3 4

Identity Crisis: Attack of the Clone

Rate Topic

Display Mode

Topic Options

Author

Message

Franl Quintana

Posted Thursday, May 12, 2011 9:25 AM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, September 04, 2011 10:24 AM
Points: 5, Visits: 40

What about the error with the schema w00t

Post #1107815

UMG Developer

Posted Thursday, May 12, 2011 2:49 PM

SSCrazy

Group: General Forum Members
Last Login: Monday, May 13, 2013 11:21 AM
Points: 2,163, Visits: 2,148

Another nice question, thanks!

Post #1108071

Peter Trast

Posted Friday, May 13, 2011 9:06 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, March 15, 2013 10:35 AM
Points: 594, Visits: 654

Tom.Thomson (5/11/2011)

WayneS (5/11/2011)

Tom.Thomson (5/11/2011)

Nice question.

One niggle: asking people to assume that a schema is valid when a table doesn't have a primary key may encourage a very bad habit if some of your audience don't know any better. Maybe "pretend" would have been a better choice of word than "assume".

Tom, I think it was referring to the schema "Playground", which the table was created in.

Ah, yes, probably. My mistake. I find it hard at times to remember that MS misuses this particular term so horribly, and my reaction Alien

was as it was because I interpreted "schema" as "schema" rather than as what MS calls "schema". Must remember loony MS terminology in future Sad

True many people are unaware of all the implications of "schema" in SQL as it covers many things "to make SQL databases and objects self-describing". Things like structure and integrity constraints, security and authorization specifications, object identifiers, features and packages, support of features, implementation information and sizing items, and schema is actually divided into "information" and "definition" schemas.

So loony Hehe

actually applies to the description of schema by many MS DBA's, not Microsoft itself. Unfortunately, many DBA's just never really learn how broadly the term applies and tend to assume the third position of the name resolution process only...

But we're all learning!!

Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems

Post #1108518