一、ORACLE
查某个架构下的所有表注释
select
A.OWNER 架构名,
A.TABLE_NAME 表名,
MENTS 表解释,
A.COLUMN_NAME 字段名,
MENTS 字段解释
from dba_col_comments A
LEFT JOIN dba_tab_comments B ON A.TABLE_NAME=B.TABLE_NAME AND B.OWNER=架构名 AND B.TABLE_TYPE=TABLE
WHERE A.OWNER=TMAIN
二、SQLSERVER
SELECT
sch.NAME 架构名,
tab.name 表名,
ISNULL(ep2.value, \) 表解释,
col.colorder 序号,
col.name 列名,
ISNULL(ep.value, \) 列说明,
ind.rows 表数据量,
t.name 数据类型,
col.length 长度,
ISNULL(COLUMNPROPERTY(col.id, col.name, Scale), 0) AS 小数位数,
CASE WHEN COLUMNPROPERTY(col.id, col.name, IsIdentity) = 1 THEN √ ELSE \ END AS 标识,
CASE WHEN EXISTS( SELECT 1 FROM dbo.sysindexes si
INNER JOIN dbo.sys