SQLserver 根据字段找到对应的数据库，数据表的SQL命令

 其中只需要改变ctp_order，因为他是你自己知道的字段名字，其余不用动

-- 根据字段找到表 以及 对应的注释和说明  。其中只需要修改下面的'ctp_ctmname'

SELECT 
    DB_NAME() AS '数据库',
    s.name AS '模式',
    t.name AS '表名',
    c.name AS '列名',
    ep.value AS '注释'
FROM 
    sys.tables t
JOIN 
    sys.columns c ON t.object_id = c.object_id
JOIN 
    sys.schemas s ON t.schema_id = s.schema_id
LEFT JOIN 
    sys.extended_properties ep ON ep.major_id = c.object_id AND ep.minor_id = c.column_id AND ep.class = 1 AND ep.name = 'MS_Description'
WHERE 
    c.name = 'ctp_ctmname';