How do I list all the columns in a table?

For SQL Server

sp_help tablename

For MS SQL Server:

select COLUMN_NAME from information_schema.columns where table_name = 'tableName'

Just a slight correction on the others in SQL Server (schema prefix is becoming more important!):

SELECT name
FROM sys.columns
WHERE [object_id] = OBJECT_ID(N'dbo.tablename');

**AWS Athena**

To list all columns from a table you can use:

SHOW COLUMNS {FROM|IN} database_name.table_name
or

SHOW COLUMNS {FROM|IN} table_name [{FROM|IN} database_name]

The FROM and IN keywords can be used interchangeably.


[AWS Athena doc][1]


[1]:

[To see links please register here]