#table fields

[sqlnotepad-blog]

Table fields

SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, IS_NULLABLE

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = [THE_TABLE_NAME_HERE] ORDER BY TABLE_CATALOG, TABLE_NAME, ORDINAL_POSITION