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);
Last updated: 05-23-2005 22:06:11