sql & oracle 查询表的字段名

sql：

SELECT Name from SysColumns  WHERE id=Object_Id(tablename) order by colorder

 

select name from syscolumns where id=(select max(id) from sysobjects where xtype='u' and name='CB_ShipBasic')

 

--读取库中的所有表名
select name from sysobjects where xtype='u'

 

oracle：

select A.COLUMN_NAME
,A.TABLE_NAME, ROWNUM AS ROWNO

from USER_TAB_COLUMNS A

where TABLE_NAME = 'tablename'

ORDER BY A.COLUMN_ID