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

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

--检查表的描述信息为空的sqlSELECT 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 NULLAND 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_NAMEWHERE 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_NAMEWHERE 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