对于SQL Server:

SELECT [name] AS [Column Name]
FROM syscolumns
WHERE id = object_id('TABLE_NAME')

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

sp_columns TABLE_NAME

describe YOUR_TABLE;

在你的情况下:

describe EVENT_LOG;

你可以这样做:

describe EVENT_LOG

or

desc EVENT_LOG

注意:只适用于你知道表名，特别是Oracle。

对于SQL Server:

SELECT [name] AS [Column Name]
FROM syscolumns
WHERE id = object_id('TABLE_NAME')

您可以运行此查询

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;