Introduction:
Here
I will explain simple SQL Query to get all
table, procedure names in database or How to get list of all tables names in SQL Server Database or
How to Get list of all procedures in SQL Server database.
Description:
In
previous articles I explained many articles relating to SQL Server. Now I will
explain how to get all tables and stored procedures in database using SQL Server.
Get
List of table names in database
To
get list of tables in SQL Server we need to
write the query like as shown below
USE SampleDB
SELECT * FROM SYS.TABLES
|
Get
List of Stored Procedures in database
To
get list of procedures in SQL Server we need to
write the query like as shown below
USE SampleDB
SELECT * FROM SYS.PROCEDURES
|
0 comments :
Post a Comment