Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

What are the steps to follow when preparing to create a table?

user-image
Question ajoutée par Emad Mohammed said abdalla , ERP & IT Software, operation general manager . , AL DOHA Company
Date de publication: 2015/01/07
Vinod Jetley
par Vinod Jetley , Assistant General Manager , State Bank of India

The create table statement is used to create a new table. Here is the format of a simple create table statement:

create table "tablename" ("column1" "data type", "column2" "data type", "column3" "data type");

Format of create table if you were to use optional constraints:

create table "tablename" ("column1" "data type" [constraint], "column2" "data type" [constraint], "column3" "data type" [constraint]); [ ] = optional

Note: You may have as many columns as you'd like, and the constraints are optional.

More Questions Like This