title: SQL statement to grab table names, views, and stored procs, order by schema
body: <p>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?</p>
  
  <p>I would like to generate an Excel spreadsheet from this list with the columns: schema, type (table, view, stored proc), and name.</p>