CREATE TABLE
Este comando é utilizado para criar tabela no banco de dados.
CREATE TABLE S_DEPT
( ID NUMBER(6),
NAME VARCHAR2(40),
REGION_ID NUMBER(6),
CONSTRAINT PK_DEPT PRIMARY KEY (ID)
);
CREATE TABLE S_EMP
( EMP_ID NUMBER(6),
DEPT_ID NUMBER(6),
LAST_NAME VARCHAR2(30),
MANAGER_ID NUMBER(4),
SALARY NUMBER(10,2),
COMMISSION_PCT NUMBER(10,2),
TITLE VARCHAR2(40),
COMM NUMBER(10,2),
FIRST_NAME VARCHAR2(30 BYTE),
START_DATE DATE,
CONSTRAINT PK_EMP PRIMARY KEY (EMP_ID)
CONSTRAINT FK_EMP_DEPT FOREIGN KEY (DEPT_ID)
REFERENCES S_DEPT (ID) ENABLE
);
CREATE TABLE S_DEPT
( ID NUMBER(6),
NAME VARCHAR2(40),
REGION_ID NUMBER(6),
CONSTRAINT PK_DEPT PRIMARY KEY (ID)
);
CREATE TABLE S_EMP
( EMP_ID NUMBER(6),
DEPT_ID NUMBER(6),
LAST_NAME VARCHAR2(30),
MANAGER_ID NUMBER(4),
SALARY NUMBER(10,2),
COMMISSION_PCT NUMBER(10,2),
TITLE VARCHAR2(40),
COMM NUMBER(10,2),
FIRST_NAME VARCHAR2(30 BYTE),
START_DATE DATE,
CONSTRAINT PK_EMP PRIMARY KEY (EMP_ID)
CONSTRAINT FK_EMP_DEPT FOREIGN KEY (DEPT_ID)
REFERENCES S_DEPT (ID) ENABLE
);
0 comentários: