Skip to content

Instantly share code, notes, and snippets.

@sankars
Created April 29, 2014 06:55
Show Gist options
  • Select an option

  • Save sankars/11392497 to your computer and use it in GitHub Desktop.

Select an option

Save sankars/11392497 to your computer and use it in GitHub Desktop.
Meta Queries
-- From http://stackoverflow.com/questions/175415/how-do-i-get-list-of-all-tables-in-a-database-using-tsql
-- list all tables
SELECT * FROM information_schema.tables
SELECT * FROM sysobjects WHERE xtype='U'
SELECT * FROM sys.tables;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment