Sql Server查看字段 结构
2020-05-14 本文已影响0人
hanscang
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'
百度所得，地址遗失，记录一下
