describe YOUR_TABLE;

在你的情况下:

describe EVENT_LOG;

你也可以试试这个，但它可能比你需要的信息更多:

sp_columns TABLE_NAME

该信息存储在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 t.name AS table_name,
SCHEMA_NAME(schema_id) AS schema_name,
c.name AS column_name
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE c.name LIKE '%%' --if you want to find specific column write here 
ORDER BY schema_name, table_name;

SELECT COLUMN_NAME 'all_columns' 
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE TABLE_NAME='user';

我是这样做的

SELECT 
    TOP 0
    *
FROM
    Posts

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