sp_tables

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.





This entry was posted in . Bookmark the permalink.

Leave a reply