Oracle与MySQL差异之表结构查询
-- Oracle
-- 表信息
SELECT * FROM USER_TABLES;
SELECT * FROM USER_TAB_COMMENTS;
-- 表字段信息
SELECT * FROM USER_TAB_COLUMNS;
SELECT * FROM USER_COL_COMMENTS;
SELECT * FROM USER_PART_KEY_COLUMNS;
-- 表分区信息
SELECT * FROM USER_TAB_PARTITIONS;
-- MySQL
-- 注意添加这个条件 table_schema = (select database())
show TABLES from INFORMATION_SCHEMA;
-- 表信息(包含表注释)
select * from information_schema.tables;
-- 表字段信息
select * from information_schema.columns;
select * from information_schema.key_column_usage;
-- 表分区信息
select * from information_schema.PARTITIONS;