Database SQL / Scripts for '#DDL'

Database SQL / Scripts for '#DDL' - 3 Query/Script(s) found

Sample 1. Oracle - Add New Date Column to a Table

ALTER TABLE TABLE_NAME

ADD NEW_COLUMN DATE;

_{Like Feedback DDL alter table add a column add a new column sql}

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}

Search Database SQL / Scripts