查询表详情

in sql •  6 years ago 

在command模式下,输入 desc 表名
在sql下可用

select t.table_name,t.column_name,c.DATA_TYPE||'(' ||c.DATA_LENGTH||')',t.comments from USER_COL_COMMENTS t,USER_TAB_COLUMNS c
where c.column_name= t.column_name and c.TABLE_NAME='表名大小写注意' and c.TABLE_NAME=t.TABLE_NAME

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!