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