Query the column name of each table using SQL statements

exec sp_columns tableName

The above line of code can find out all of the table column, instead of Sp_pkeys, you can find the table's primary key.
But if I want to only find out the COLUMN name,select column_name from (exec sp_columns tableName) as A, it is not possible to write, you must create a table, insert data into it.

There is another way to directly query:

Select  from where object_name (ID) = ' t Ablename ' Select  from where = object_id ('tableName')

Query the column name of each table using SQL statements