SELECT
column_name
,data_type
,udt_name
,character_maximum_length
,is_nullable
,is_identity
FROM
information_schema.columns
WHERE
table_name = 'yourtablename'
;
SELECT
column_name
,data_type
,udt_name
,character_maximum_length
,is_nullable
,is_identity
FROM
information_schema.columns
WHERE
table_name = 'yourtablename'
;