Sql Server查看字段 结构

SELECT
a.name,b.name,c.DATA_TYPE,b.max_length 
FROM sys.tables a 
JOIN sys.columns b on b.object_id = a.object_id
JOIN INFORMATION_SCHEMA.COLUMNS c on b.name=c.COLUMN_NAME and a.name=c.TABLE_NAME
WHERE a.name='OC_ChargeOrder_WideTable_202001'
and b.name = 'Code'

百度所得，地址遗失，记录一下