检查表或字段的描述信息是否为空

 --检查表列的描述信息为空的sql               
SELECT O.name,C.name,PFD.value FROM SYS.objects O 
LEFT JOIN  sys.columns C ON  O.object_id = C.object_id
LEFT JOIN sys.extended_properties PFD ON PFD.class = 1
             AND C.[object_id] = PFD.major_id AND C.column_id = PFD.minor_id
WHERE O.type_desc ='USER_TABLE'
AND PFD.value IS NULL
AND O.name LIKE 'FA_%'
ORDER BY O.name

--检查表的描述信息为空的sql
SELECT O.name,PTB.value FROM  SYS.objects O 
LEFT JOIN sys.extended_properties PTB        
              ON PTB.class=1             
              AND PTB.minor_id=0            
               AND O.[object_id]=PTB.major_id
               
WHERE O.type_desc ='USER_TABLE'
AND PTB.value IS NULL
AND O.name LIKE 'FA_%'
ORDER BY O.name

 

以下为ORACLE脚本

SELECT A1.TABLE_NAME, 
       A4.COMMENTS 表描述,
       A1.COLUMN_NAME   字段名称,
       A2.COMMENTS  字段描述
FROM    USER_TAB_COLUMNS  A1
     LEFT JOIN USER_COL_COMMENTS   A2  ON   A1.TABLE_NAME = A2.TABLE_NAME AND A1.COLUMN_NAME = A2.COLUMN_NAME
     LEFT JOIN USER_TAB_COMMENTS A4    ON   A1.TABLE_NAME = A4.TABLE_NAME
WHERE A4.TABLE_TYPE = 'TABLE' 
     AND  (A4.COMMENTS IS NULL OR  A2.COMMENTS IS NULL )
     AND A1.TABLE_NAME LIKE 'FA_%'
     ORDER BY  A1.TABLE_NAME

SELECT T.TABLE_NAME,C.COMMENTS  
FROM USER_TABLES T 
     LEFT JOIN USER_TAB_COMMENTS  C ON  T.TABLE_NAME = C.TABLE_NAME
WHERE C.TABLE_TYPE = 'TABLE' 
     AND  C.COMMENTS IS NULL
     AND T.TABLE_NAME LIKE 'FA_%'
     ORDER BY T.TABLE_NAME

 

 

--直接查询描述信息为空的字段
SELECT * FROM DBA_COL_COMMENTS 
WHERE OWNER = ? 
AND COMMENTS IS NULL 
ORDER BY TABLE_NAME

--直接查询表描述信息为空的方法
SELECT * FROM DBA_TAB_COMMENTS 
WHERE OWNER = ? 
AND COMMENTS IS NULL 
ORDER BY TABLE_NAME