Format:
Recent snippets matching tags of INFORMATION_SCHEMA
select * from INFORMATION_SCHEMA.COLUMNS where table_name not like 'v%' order by TABLE_NAME, ORDINAL_POSITION select * from INFORMATION_SCHEMA.ROUTINES select * from INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE select * from INFORMATION_SCHEMA.KEY_COLUMN_USAGE SELECT s.name [SPECIFIC_SCHEMA], o.name [SPECIFIC_NAME], s.name [ROUTINE_SCHEMA], o.name [ROUTINE_NAME], case when o.[type] in ('P', 'PC') then 'PROCEDURE' when o.type in ('V') then 'VIEW'
98 Views
no comments
Subscribe
Discuss
What's new
What is it
New Snippet
Recent Snippets
My Snippets
Web Code
Search
