1. SQL Query for selecting database objects
SELECT * FROM SYS.OBJECTS
2. SQL Query for selecting database Stored Procedurers
SELECT * FROM SYS.OBJECTS WHERE TYPE = 'P' ORDER BY NAME ASC
3. SQL Query for selecting database Tables
SELECT * FROM SYS.OBJECTS WHERE TYPE = 'U' ORDER BY NAME ASC
4.SQL Query for selecting database Functions
SELECT * FROM SYS.OBJECTS WHERE TYPE = 'FN' ORDER BY NAME ASC
5.SQL Query for selecting database Primary Keys
SELECT * FROM SYS.OBJECTS WHERE TYPE = 'PK' ORDER BY NAME ASC
