SQL——获取数据库表结构
时间：2021-07-01 10:21:17
帮助过：3人阅读
from information_schema
.COLUMNS as a
left join sys.extended_properties as b on a.TABLE_NAME=OBJECT_NAME(b.major_id)
and
a.ORDINAL_POSITION=b.minor_id
where
a.TABLE_NAME=‘tableName‘
SQL——获取数据库表结构
标签：ram HERE params func ble function rom ati har
