Useful Sql Server Statements
1. Search through Column Name: - Suppose you want to know how many objects have the same column name. You can use this sql statement.
For Sql Server 2000:-
Select * from sysobjects where id in (Select * from Syscolumn where name='ColumnName')
For Sql Server 2005:-
select * from sys.objects where object_id in
(select object_id from sys.columns where name='ColumnName')
2. Search through Query statement: - Suppose you have a query and you want to know if this query is used in which views or which procedure. You can use this sql statement.
Select * from syscomments where name like ('%your Sql Query%')
3. Search constraint used in whole database: -Suppose you want to view all the constraint used in your database. You can use this sql statement.
select pr.name,fr.parent_object_id,fr.name,fr.type_desc from sys.objects pr,
sys.objects Fr where pr.type<>'s'
order by fr.parent_object_id