CREATE, ALTER, DROP CREATE statement syntax => CREATE objectType objectName attributes; CREATE TABLE "SCOTT"."PRODUCTS" ( "PRODUCT_ID" NUMBER(10,0) NOT NULL ENABLE, "SUPPLIER_ID" NUMBER(10,0) NOT NULL ENABLE, "PRODUCT_NAME" VARCHAR2(20), "REGION_ID" NUMBER(10,0), UNIQUE ("PRODUCT_ID"), CONSTRAINT "FK_SUPPLIER" FOREIGN KEY ("SUPPLIER_ID") REFERENCES "SCOTT"."SUPPLIER" ("SUPPLIER_ID") ENABLE, CONSTRAINT "FK_REGION" FOREIGN KEY ("REGION_ID") REFERENCES "SCOTT"."REGIONS" ("REGION_ID") ENABLE ) CREATE TABLE "SCOTT"."REGIONS" ( "REGION_ID" NUMBER(10,0), "REGION_NAME" VARCHAR2(20), CONSTRAINT "PK_REGION" PRIMARY KEY ("REGION_ID") ) CREATE TABLE "SCOTT"."SUPPLIER" ( "SUPPLIER_ID" NUMBER(10,0) NOT NULL ENABLE, "SUPPLIER_NAME" VARCHAR2(50) NOT NULL ENABLE, "CONTACT_NAME" VARCHAR2(50), CONSTRAINT "SUPPLIER_PK" PRIMARY KEY ("SUPPLIER_ID") ) |