Create (SQL)

A CREATE statement in SQL creates an object inside of a relational database management system (RDBMS). The types of objects that can be created depends on which RDBMS is being used, but most support the creation tables, indexes, users, and databases. Some systems (such as PostgreSQL) allow CREATE and other DDL comands to occur inside of a transaction and thus be rolled back.

The typical usage is CREATE objecttype objectname parameters. For example, the command to create a table named employees with a single column would be:

CREATE TABLE employees (id INTEGER);