Translate

Monday, October 17, 2011

SQL Server : Find all stored procedures

Find all stored procedures in a database:
select * from sys.objects where type_desc='SQL_STORED_PROCEDURE'


Find all the scalar functions in a database:
select * from sys.objects where type_desc='SQL_SCALAR_FUNCTION'


Find all tables in a database:
select * from sys.objects where type_desc='USER_TABLE'

Find all columns in a database:
select * from sys.columns

Find all triggers in a database:
select * from sys.objects where type_desc='SQL_TRIGGER'

Find all the views in a database
select * from sys.objects where type_desc='VIEW'


No comments:

Post a Comment

Comments will appear once they have been approved by the moderator