Jump to content

Create (SQL)

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by Turnstep (talk | contribs) at 17:49, 6 April 2005 (Created create). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.
(diff) ← Previous revision | Latest revision (diff) | Newer revision → (diff)

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, 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);