Database SQL / Scripts for '#Constraint'

Database SQL / Scripts for '#Constraint' - 5 Query/Script(s) found

Sample 1. Oracle - Create Table with Primary Key, Not Null and Foreign Key Constraints

CREATE TABLE TABLE_NAME (

  ID            NUMBER        CONSTRAINT ID_KEY PRIMARY KEY,

  NAME          VARCHAR(50)   CONSTRAINT NAME_NOT_NULL NOT NULL,

  CONSTRAINT NAME_FK FOREIGN KEY (NAME) REFERENCES OTHER_TABLE_NAME (NAME)

);

_{Like Feedback create table create table with foreign key}

Sample 2. Drop a Constraint from a Table

ALTER TABLE TABLE_NAME

DROP CONSTRAINT CONSTRAINT_NAME;

_{Like Feedback drop a constraint ALTER DROP CONSTRAINT DDL}

Sample 3. Add Primary Key constraint to a Table

ALTER TABLE TABLE_NAME

ADD CONSTRAINT CONSTRAINT_NAME primary key (COLUMN_NAME);

_{Like Feedback Add Primary Key Constraint Constraint Alter Table Alter ADD CONSTRAINT DDL}

Sample 4. Set Primary Key on an already created table

ALTER TABLE EMPLOYEE

ADD CONSTRAINT EMPLOYEE#ID_PRIMARY_KEY

PRIMARY KEY (ID);

_{Like Feedback set primary key after table creation add primary key constraint}

Sample 5. Adding Composite Key as Primary Key

ALTER TABLE TABLE_NAME

ADD CONSTRAINT CONSTRAINT_NAME primary key (COLUMN_1_NAME,COLUMN_2_NAME );

_{Like Feedback composite primary key primary key alter alter table constraint add constraint}

Search Database SQL / Scripts