SQL

sql get table columns list sql

sp_columns [tablename]

list all columns in a table sql

SHOW COLUMNS FROM table_name

list table columns sql

DESCRIBE table_name; /* List all columns of a database's table*/

list-table-columns- in-sql-server

select schema_name(tab.schema_id) as schema_name,
    tab.name as table_name, 
    col.column_id,
    col.name as column_name, 
    t.name as data_type,    
    col.max_length,
    col.precision
from sys.tables as tab
    inner join sys.columns as col
        on tab.object_id = col.object_id
    left join sys.types as t
    on col.user_type_id = t.user_type_id
order by schema_name,
    table_name, 
    column_id;