How do I list all the columns in a table?

For MySQL, use:

DESCRIBE name_of_table;

This also works for Oracle as long as you are using SQL*Plus, or Oracle's SQL Developer.

sql mysql sql-server database oracle

For Oracle (PL/SQL)

SELECT column_nameFROM user_tab_colsWHERE table_name = 'myTableName'

For MySQL

SHOW COLUMNS FROM table_name

sql mysql sql-server database oracle

For MS SQL Server:

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

CodeHunter