-
Notifications
You must be signed in to change notification settings - Fork 192
Closed
Description
Example:
--------------------------------------------------------
-- DDL for Table TableName
--------------------------------------------------------
CREATE TABLE "SchemaName"."TableName"
("COL1" VARCHAR2(10 CHAR),
"COL2" VARCHAR2(8 CHAR));
--------------------------------------------------------
-- DDL for Index IDX_TableName
--------------------------------------------------------
CREATE INDEX "SchemaName"."IDX_TableName" ON "SchemaName"."TableName" (SUBSTR("COL2",1,6));
--------------------------------------------------------
-- DDL for Index PK_TableName
--------------------------------------------------------
CREATE UNIQUE INDEX "SchemaName"."PK_TableName" ON "SchemaName"."TableName" ("COL1");
--------------------------------------------------------
-- Constraints for Table TableName
--------------------------------------------------------
ALTER TABLE "SchemaName"."TableName" MODIFY ("COL1" NOT NULL ENABLE);
ALTER TABLE "SchemaName"."TableName" ADD CONSTRAINT "PK_TableName" PRIMARY KEY ("COL1");
Metadata
Metadata
Assignees
Labels
No labels