How to List all Columns in a SQL Server Table

To list all columns in the ‘Person.Address’ Table in the AdventureWorks database, run the following query:

USE AdventureWorks
SELECT TABLE_CATALOG AS Database_Name, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'Person'
AND TABLE_NAME = 'Address'

list_all_table_columns

Read related blog posts:
List all Nullable or Non-Nullable Columns in a SQL Server Table
How to check if the Column exists in a SQL Server Table