我是这样做的

SELECT 
    TOP 0
    *
FROM
    Posts

它甚至可以在http://data.stackexchange.com的服务表我不知道!

试试这个

select * from sys.all_columns c join sys.objects o on c.object_id=o.object_id where o.name = 'TABLENAME' and c.name like '%COLUMN NAME%'

SELECT A.COLUMN_NAME, A.* FROM all_tab_columns a 
WHERE table_name = 'Your Table Name'
AND A.COLUMN_NAME = 'COLUMN NAME' AND a.owner = 'Schema'

这也是我们可以使用它的一种方式

select * from product where 1 != 1

该信息存储在ALL_TAB_COLUMNS系统表中:

SQL> select column_name from all_tab_columns where table_name = 'DUAL';

DUMMY

或者你可以描述表，如果你使用SQL*PLUS:

SQL> desc dual
Name                               Null?    Type
----------------------------------------------------- -------- ---------------------- -------------
DUMMY                               VARCHAR2(1)

select column_name,* from information_schema.columns
 where table_name = 'YourTableName'
order by ordinal_position