What does "S" mean?

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 Nanda Kishore » What does "S" mean?

What does "S" mean?

Rate Topic

Display Mode

Topic Options

Author

Message

JCass

Posted Friday, March 14, 2008 2:02 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, February 11, 2013 4:53 AM
Points: 12, Visits: 51

What does this mean:
"If you are using any object type code as “S” this will not work. System tables (S) are not exposed"

Does it mean you can not use S as a table name for instance?

Post #469224

RBarryYoung

Posted Friday, March 14, 2008 11:40 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855, Visits: 9,374

The sysobjects table returns a list of every object in the database. One of the columns is Object Type which is "P" for a stored procedure, "V" for a view, "T" for a user table, etc., including "S" for a System Table.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."

Post #469573

RBarryYoung

Posted Friday, March 14, 2008 11:46 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855, Visits: 9,374

Just to clarify: Yes, you can use "S" as a table name.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."

Post #469577

« Prev Topic | Next Topic »

Permissions