栏位"/>
ORACLE和GREEN PLUM查看某个表都有哪些栏位
ORACLE数据库来查看某个表都有哪些表栏位,且排序:
SELECT
*
FROM
user_tab_columns
WHERE
Table_Name = ‘表名称’
ORDER BY
column_id ASC;
green plum数据库来查看某个表都有哪些表栏位:
select
*
from
information_schema.columns
where
1=1
– and table_schema = ‘schema名称’
and table_name = ‘表名称’;
更多推荐
ORACLE和GREEN PLUM查看某个表都有哪些栏位
发布评论