Search DB Schema
atomicbomb
Posts: 4
Description: Generates sql code to search the schema of a database, useful for big db's where tables have lots of columns, and you can't remember which table it's in 
Shortcut: sis (search in schema)
Code:
-- Set the database
Use [put your db here]
-- Exclude views and variable names
Select S.Name, T.Name, O.Name As [Object Name]
From SysColumns S
Inner Join SysObjects O on S.ID = O.ID
Inner Join SysTypes T On T.XType = S.XType
Where {(}S.Name Like '{%}name{%}'{)}
And {(}O.Name Not Like 'vw{%}'{)}
And {(}S.Name Not Like '@{%}'{)}
Shortcut: sis (search in schema)
Code:
-- Set the database
Use [put your db here]
-- Exclude views and variable names
Select S.Name, T.Name, O.Name As [Object Name]
From SysColumns S
Inner Join SysObjects O on S.ID = O.ID
Inner Join SysTypes T On T.XType = S.XType
Where {(}S.Name Like '{%}name{%}'{)}
And {(}O.Name Not Like 'vw{%}'{)}
And {(}S.Name Not Like '@{%}'{)}
