sp_tables is a system stored procedure which will result in all the table names and view names in a particular database:
Syntac for sp_tables is :
sp_tables
Example:
I executed sp_tables stored procedure in example database. Below picture represents the execution result for this.
Syntac for sp_tables is :
sp_tables
Example:
I executed sp_tables stored procedure in example database. Below picture represents the execution result for this.
