oracle与sql查询表字段与类别

----------oracle查询所有表-------------

SELECT
    TABLE_NAME
FROM
    all_tables
WHERE    OWNER = 'PORTAL_HIS'     
--and GLOBAL_STATS='NO'
ORDER BY table_name

----------oracle查询表字段-------------
SELECT COLUMN_NAME,DATA_TYPE FROM user_tab_columns where table_name = upper
('BA_BAJY')

----------sql查询所有表-------------
Select name  From sysobjects  where xtype='U'
----------sql查询表字段-------------
Select name  from syscolumns Where ID=OBJECT_ID('tb')
----------sql查询表字段与类别-------------
select column_name,data_type from information_schema.columns 
where table_name = 'tb'