Bienvenido al sitio de software libre de CUTE, editor de bases de datos para MS Access y SQL Server. Este proyecto necesita reanimación desde Marzo de 2013.

 

Se puede realizar mediante donaciones, patrocinio o ayuda en la instalación.

donate sponsor aided installation
 

O puedes ayudar escribiendo nuevas traducciones, un artículo en la wikipedia acerca del programa, comentarios en foros o blogs, añadir código o documentación, etc... En cualquier caso gracias.

Create Table (SQL)

Create - To make a new database, table, index, or stored query. 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 of tables, indexes, users, synonyms and databases. Some systems (such as PostgreSQL) allow CREATE, and other DDL commands, inside of a transaction and thus they may be rolled back.

Perhaps the most common CREATE command is the CREATE TABLE command. The typical usage is:

CREATE [TEMPORARY] TABLE [table name] ( [column definitions] ) [table parameters].

Column Definitions: A comma-separated list consisting of any of the following

  • Column definition: [column name] [data type] {NULL | NOT NULL} {column options}
  • Primary key definition: PRIMARY KEY ( [comma separated column list] )
  • CONSTRAINTS: {CONSTRAINT} [constraint definition]
  • RDBMS specific functionality

For example, the command to create a table named employees with a few sample columns would be:

For example, the command to create a table named employees with a few sample columns would be:

CREATE TABLE employees (   
    id            INTEGER   PRIMARY KEY,
    first_name    CHAR(50)  NULL,
    last_name     CHAR(75)  NOT NULL,
    dateofbirth   DATE      NULL
);

Content extracted from free documentation.

Comments:

Add your comment:

Gender:
(Too weird, even outrageous perhaps?: try a regeneration)
Top of the page