sp_tables

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 VM » sp_tables

20 posts, Page 2 of 2

««1 2

sp_tables

Rate Topic

Display Mode

Topic Options

Author

Message

Koen Verbeeck

Posted Tuesday, November 30, 2010 10:04 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 1:21 AM
Points: 9,374, Visits: 6,471

Nice question, thanks.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1028090

SanDroid

Posted Tuesday, November 30, 2010 10:12 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,232, Visits: 1,046

Nice Question!
I liked the way I learned something from the answer.
Never tought before about how it lists System Tables as a TABLE object even though they are differant from user created TABLE objects. Cool

Post #1028096

payal vyas

Posted Tuesday, November 30, 2010 11:00 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, March 11, 2011 11:22 PM
Points: 19, Visits: 36

I too answered incorrectly after reading the documentation of msdn. The statment "any object that can appear in a FROM clause, except synonym objects", made me assume that user defined functions too would be included.

Post #1028135

jaganmohan.rao

Posted Tuesday, November 30, 2010 11:44 PM

SSC Eights!

Group: General Forum Members
Last Login: Monday, March 25, 2013 4:03 AM
Points: 850, Visits: 71

Good question. Keep it up.

Regards,
Jagan.

Post #1028431

Koen Verbeeck

Posted Wednesday, December 01, 2010 12:37 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 1:21 AM
Points: 9,374, Visits: 6,471

payalvyas11 (11/30/2010)

True, the documentation can be confusing, but if you've read further, you would have noticed by result sets: TABLE_TYPE --> table, system table or view.

This leaves very little doubt of course.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1028442

L' Eomot Inversé

Posted Wednesday, December 01, 2010 5:42 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 3:07 PM
Points: 7,096, Visits: 7,156

Nice straightforward question, no tricks or traps. Pity that the MS documentation has fallen out of date, though.

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

croberts 36762

Posted Thursday, December 02, 2010 8:33 AM

SSC-Addicted

Group: General Forum Members
Last Login: Monday, April 30, 2012 12:36 PM
Points: 404, Visits: 442

When I do a 'select * from sys.tables' on a database with views, only the tables are returned, not the views. This is on SQL 2005. What am I doing wrong? Can someone verify this?

Post #1029303

Hugo Kornelis

Posted Thursday, December 02, 2010 12:20 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 3:23 AM
Points: 5,240, Visits: 7,047

You're doing nothing wrong. This is the expected and documented behaviour for sys.tables.

Note that this discussion is about the system stored procedure sp_tables, not about the catalog view sys.tables.

Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

Post #1029463