mysql与oracle查询表名表说明及字段属性

mysql

查询当前数据库

select database()

查询表

SELECT table_name,table_type, table_comment FROM information_schema.tables WHERE table_schema=‘mysql’ AND table_name=‘user’;

查询字段

SELECT column_name,column_comment FROM information_schema.columns WHERE table_schema=‘mysql’ AND table_name=‘user’;

oracle

查询表

SELECT A.TABLE_NAME, B.COMMENTS TABLE_COMMENT, B.TABLE_TYPE FROM USER_TABLES A, USER_TAB_COMMENTS B WHERE A.TABLE_NAME = B.TABLE_NAME AND A.TABLE_NAME LIKE ‘%%’ ORDER BY A.TABLE_NAME

查询字段

SELECT COLUMN_NAME COLUMN_NAME, COMMENTS COLUMN_COMMENT FROM USER_COL_COMMENTS WHERE TABLE_NAME = ‘user’ ORDER BY COLUMN_NAME