Overview
TheDESCRIBE
statement is used to show columns within a table as well as tables within a database.
It is recommended to be used before creating a new table to avoid tables duplication
Syntax
Below you can find the basic syntax for describing tables within a database as well as columns within tables:table_name
: name of the table that you want to show
This statement is available to all users with the
USAGE
privilege on the schema, where the table is locatedExamples
To get a better understanding of theDESCRIBE
statement, take a look at some examples below:
DESCRIBE Table
In this example, we will figure out the columns of the part table. In order to do so, you need to run the query below:The example above shows that the tables reside in the
public
schema (the default schema in Oxla). You can also display tables from other schemas, by following the doc here