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'
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