sp_tables SQL Server Example

SQL Server > System Stored Procedures   > sp_tables

Returns a list of tables and views that can be queried in the current environment.

Example:

EXEC sp_tables;