Search notes:

SQL Server: sp_tables

Find all tables in a given schema: 
exec sp_tables @table_owner = 'information_schema'

See also

The names of columns can be found with the stored procedure sp_columns.

Index