SQL statement to grab table names, views, and stored procs, order by schema

Posted by sunpech on Stack Overflow See other posts from Stack Overflow or by sunpech
Published on 2010-03-25T14:10:29Z Indexed on 2010/03/25 14:13 UTC
Read the original article Hit count: 300

Filed under:
|
|

Is there a SQL statement that will list the names of all the tables, views, and stored procs from MS SQL Server database, ordered by schema name?

I would like to generate an Excel spreadsheet from this list with the columns: schema, type (table, view, stored proc), and name.

© Stack Overflow or respective owner

Related posts about sql

Related posts about excel