Creating a database structure
After the database is created, the following three SQL statements will allow you to create and change the database structure. This is done through database entities, such as a table, function, or constraint:
- The
CREATEstatement creates the database entity. - The
ALTERstatement changes the database entity. - The
DROPstatement deletes the database entity.
There are also various SQL statements that allow you to inquire about each database entity. Such statements are database-specific and, typically, they are only used in a database console. For example, in the PostgreSQL console, \d <table> can be used to describe a table, while \dt lists all the tables. Refer to your database documentation for more details.
To create a table, you can execute the following SQL statement:
CREATE TABLE tablename ( column1 type1, column2 type2, ... );
The limitations for a table name, column names, and types of values that can be used depend...