Nice straightforward question, no tricks or traps. Pity that the MS documentation has fallen out of date, though.
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?
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.
Thanks Hugo. I have forgotten how to read.
Nice question, thanks!
Viewing 5 posts - 16 through 19 (of 19 total)