ORACLE:
select
A.TABLE_NAME,
A.COLUMN_NAME,
A.DATA_TYPE
from
ALL_TAB_COLUMNS A
WHERE
A.TABLE_NAME ='表名'
SQL SERVER 2000
SELECT * FROM SysColumns WHERE id=Object_Id('表名')
ORACLE:
select
A.TABLE_NAME,
A.COLUMN_NAME,
A.DATA_TYPE
from
ALL_TAB_COLUMNS A
WHERE
A.TABLE_NAME ='表名'
SQL SERVER 2000
SELECT * FROM SysColumns WHERE id=Object_Id('表名')