list all columns in table using SQL

Question

How to list all columns using SQL query?

score 1 · Answer 1 · edited Mar 25 '21 at 06:09

1

select column_name, data_type, character_maximum_length
    from INFORMATION_SCHEMA.COLUMNS 
    where table_name = '**table_name**';

edited Mar 25 '21 at 06:09

Squirrel

answered Mar 25 '21 at 06:01

iBala

You might want to explain what the code does. Code only answers are rarely useful to future readers. – BDL Mar 25 '21 at 09:33

1 Answers1