1.Oracle查询所有表名
select T.table_name as 表名,T.comments as 说明 from user_tab_comments T where T.comments --is not null
2.Oracle查询表结构
--查询所有表表结构
SELECT T1.TABLE_NAME 表名,T1.COLUMN_NAME 字段名,
T1.NULLABLE 允许空值,T1.DATA_TYPE || '(' || T1.DATA_LENGTH || ')' 数据类型,
T1.data_length 长度,T1.Data_default 缺省值,T2.COMMENTS 备注
FROM USER_TAB_COLS T1, USER_COL_COMMENTS T2
WHERE T1.TABLE_NAME = T2.TABLE_NAME AND T1.COLUMN_NAME = T2.COLUMN_NAME
--AND T1.TABLE_NAME ='users'; --查询特定表的话在此修改表名即可(Oracle查询单表表结构为空?)
3.SQL server查询表结构:
--查询所有表表结构
SELECT syscolumns.name,systypes.name,syscolumns.isnullable, syscolumns.length
FROM syscolumns, systypes
WHERE syscolumns.xusertype = systypes.xusertype
--AND syscolumns.id = object_id('表名')--查询某表表结构