Created
February 19, 2016 22:40
-
-
Save ronmichael/d0a418d859e5d5c1fad4 to your computer and use it in GitHub Desktop.
A view of all tables and columns
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| select | |
| dbo.sysobjects.name TableName, | |
| dbo.syscolumns.name ColumnName, | |
| dbo.systypes.name as Type | |
| from dbo.sysobjects | |
| join dbo.syscolumns on dbo.syscolumns.id = dbo.sysobjects.id | |
| join dbo.systypes on dbo.systypes.xtype = dbo.syscolumns.xtype | |
| where dbo.systypes.name != 'sysname' | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment