Wednesday 19 June 2013

Get List of All Stored Procedures & Table Names from Database in SQL Server

For Storeprocedures
================
USE YourDatabaseName
SELECT * FROM SYS.PROCEDURES

For Table Names
============
USE YourDatabaseName
SELECT * FROM SYS.TABLES

No comments:

Post a Comment