Wednesday, October 12, 2011

SQL Query for selecting database objects

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

1 comment:

  1. This comment has been removed by a blog administrator.

    ReplyDelete