List all the table form the Database
SELECT table_name, table_schema, table_type FROM information_schema.tables ORDER BY table_name ASC;
List all the stroed procedures names form a database.
Ex:1 use Madan SELECT ROUTINE_SCHEMA, ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_TYPE = 'PROCEDURE'; Ex:2 use Madan SELECT SCHEMA_NAME(schema_id) AS [Schema], name FROM sys.objects WHERE type = 'P'; Ex:3 use Madan SELECT SCHEMA_NAME(schema_id) AS [Schema], name FROM sys.objects WHERE type_desc = 'SQL_STORED_PROCEDURE';
Comments
Post a Comment