There will be times when we want to know the structure of a table -- what all columns it has, their data types, etc.
You can use DESCRIBE or DESC depending on the DBMS you use. PostgreSQL / MySQL doesn't support DESCRIBE/ DESC however.
There will be times when we want to know the structure of a table -- what all columns it has, their data types, etc.
You can use DESCRIBE or DESC depending on the DBMS you use. PostgreSQL / MySQL doesn't support DESCRIBE/ DESC however.
Sign up for latest news