sp_tables

Question

Post reply

sp_tables

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

TomThomson SSC Guru Points: 104773 More actions · Answer 1

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

Tom

croberts 36762 SSC Eights! Points: 972 More actions · Answer 2

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?

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 3

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/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/