How do I list all the columns in a table?

by

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.

More Related Contents:

  1. Stored Procedure with optional “WHERE” parameters
  2. MySQL equivalent of DECODE function in Oracle
  3. Deferrable Constraints in SQL Server
  4. update columns values with column of another table based on condition [duplicate]
  5. What’s the correct name for an “association table” (a many-to-many relationship) [closed]
  6. How to select the nth row in a SQL database table?
  7. How do I reset a sequence in Oracle?
  8. In MySQL queries, why use join instead of where?
  9. ORA-00904: invalid identifier
  10. How to create multiple one to one’s
  11. Can a foreign key be NULL and/or duplicate?
  12. Storing JSON in database vs. having a new column for each key
  13. T-SQL Cast versus Convert
  14. Emulate MySQL LIMIT clause in Microsoft SQL Server 2000
  15. Is there any boolean type in Oracle databases?
  16. How do I create a step in my SQL Server Agent Job which will run my SSIS package?
  17. SQLite – ORDER BY RAND()
  18. SQL – How to transpose?
  19. How do I decide when to use right joins/left joins or inner joins Or how to determine which table is on which side?
  20. Splitting the string in sql server
  21. Need to list all triggers in SQL Server database with table name and table’s schema
  22. Does mysql have the equivalent of Oracle’s “analytic functions”?
  23. How can I do a BEFORE UPDATED trigger with sql server?
  24. How to sum up time field in SQL Server
  25. Can SQL Server Express LocalDB be connected to remotely?
  26. What can cause an Oracle ROWID to change?
  27. Using SQL Server as a DB queue with multiple clients
  28. The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
  29. The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions
  30. ORA-01652: unable to extend temp segment by 128 in tablespace SYSTEM: How to extend?

Leave a Comment