Get All Columns Name Type Size 

Select
c.TABLE_SCHEMA [Schema Name]
,c.TABLE_SCHEMA+’.’+ c.table_name [Table Name]
,c.column_name [Column Name]
,c.DATA_TYPE [Data Type]
,c.CHARACTER_OCTET_LENGTH [Length]
FROM information_schema.columns c
Where
c.CHARACTER_OCTET_LENGTH=-1
order by
c.TABLE_SCHEMA
,c.TABLE_NAME
,c.COLUMN_NAME

Enjoy!!

Advertisements