SELECT
COLUMN_NAME,
ORDINAL_POSITION,
DATA_TYPE,
value AS DATA_Description
FROM INFORMATION_SCHEMA.COLUMNS AS C
left JOIN ::fn_listextendedproperty (NULL, 'user', 'dbo', 'table', 'ta',
'column', default) AS E
ON C.COLUMN_NAME = E.objname
WHERE TABLE_NAME = 'ta'
SELECT
COLUMN_NAME,
ORDINAL_POSITION,
DATA_TYPE,
value AS DATA_Description
FROM INFORMATION_SCHEMA.COLUMNS AS C
left JOIN ::fn_listextendedproperty (NULL, 'user', 'dbo', 'table', 'ta',
'column', default) AS E
ON C.COLUMN_NAME = E.objname
WHERE TABLE_NAME = 'ta'
SELECT
COLUMN_NAME,
ORDINAL_POSITION,
DATA_TYPE,
name AS PROPERTY_NAME,
value AS PROPERTY_VALUE
FROM INFORMATION_SCHEMA.COLUMNS AS C
JOIN ::fn_listextendedproperty (NULL, 'user', 'dbo', 'table', '这里你忘了吧',
'column', default) AS E
ON C.COLUMN_NAME = E.objname
WHERE TABLE_NAME = '你只改了这里'
SELECT
COLUMN_NAME,
ORDINAL_POSITION,
DATA_TYPE,
name AS PROPERTY_NAME,
value AS PROPERTY_VALUE
FROM INFORMATION_SCHEMA.COLUMNS AS C
JOIN ::fn_listextendedproperty (NULL, 'user', 'dbo', 'table', 'testtable',
'column', default) AS E
ON C.COLUMN_NAME = E.objname
WHERE TABLE_NAME = 'testtable'