Get List of Stored procedure,Tables,Triggers names in database

To get list of procedures in SQL Server we need to write the query like as shown below

USE TempDB

SELECT * FROM SYS.PROCEDURES
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 TempDB

SELECT * FROM SYS.TABLES

To get list of triggers in SQL Server we need to write the query like as shown below

USE TempDB

SELECT * FROM SYS.TRIGGERS

Leave a Comment

Comments

No comments yet. Why don’t you start the discussion?

Leave a Reply