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