December 1, 2010 at 5:42 am
Nice straightforward question, no tricks or traps. Pity that the MS documentation has fallen out of date, though.
Tom
December 2, 2010 at 8:33 am
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?
December 2, 2010 at 12:20 pm
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.
December 2, 2010 at 12:26 pm
Thanks Hugo. I have forgotten how to read.
December 3, 2010 at 1:41 pm
Nice question, thanks!
Viewing 5 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply