Database SQL / Scripts for '#ALTER'

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

Sample 1. Add New Date Column with Comment

ALTER TABLE_NAME

ADD COLUMN_NAME DATE;

COMMENT ON COLUMN TABLE_NAME.COLUMN_NAME IS 'Date Column for xyz';

_{Like Feedback Add Column with comment Add a Column with comment Add Column Alter Comment COMMENT ON COLUMN}

Sample 2. 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 3. Drop a Constraint from a Table

ALTER TABLE TABLE_NAME

DROP CONSTRAINT CONSTRAINT_NAME;

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

Sample 4. 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 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