Skip to content

Instantly share code, notes, and snippets.

@chenrui333

chenrui333/findColumnInfo

Created August 6, 2014 20:51
Show Gist options
  • Save chenrui333/2aa3943ebef4b80bd65b to your computer and use it in GitHub Desktop.
Save chenrui333/2aa3943ebef4b80bd65b to your computer and use it in GitHub Desktop.
Download ZIP
SQLServer find the table and column info
Raw
findColumnInfo
select TABLE_NAME, COLUMN_NAME, IS_NULLABLE, DATA_TYPE
from Information_schema.columns
where Table_name in (
SELECT name
AS SchemaTable
FROM sys.tables
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment