Search DB Schema

atomicbombatomicbomb Posts: 4
edited February 13, 2008 11:17PM in SQL Prompt code snippets
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)

-- 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 '@{%}'{)}
Sign In or Register to comment.