sqlserver で describe 相当のことをする

SELECT column_name AS [Name],
       IS_NULLABLE AS [Null?],
       DATA_TYPE + '(' + CASE
                           WHEN Cast(CHARACTER_MAXIMUM_LENGTH AS VARCHAR(5)) = -1 THEN 'Max'
                           ELSE Cast(CHARACTER_MAXIMUM_LENGTH AS VARCHAR(5))
                         END + ')' AS [Type]
FROM   INFORMATION_SCHEMA.Columns
WHERE  table_name = 'table_name_here'

exec sp_columns 'table_name'

こっちのがよさそうか