Skip to content

Instantly share code, notes, and snippets.

@jrdmb

jrdmb/tsql schema queries.sql

Last active August 29, 2015 14:18
Show Gist options
  • Save jrdmb/f5c993e70b2780ebd9ac to your computer and use it in GitHub Desktop.
Save jrdmb/f5c993e70b2780ebd9ac to your computer and use it in GitHub Desktop.
Download ZIP
T-SQL Schema Queries
Raw
tsql schema queries.sql
SELECT * FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE = N'PROCEDURE' and ROUTINE_SCHEMA = N'dbo'
and SPECIFIC_NAME like 'usp%'
select TABLE_NAME from INFORMATION_SCHEMA.TABLES
#tsql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment