Search Database SQL / Scripts


  Help us in improving the repository. Add new Queries/Scripts through 'Submit Database SQL / Scripts ' link.





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

ALTER TABLE TABLE_NAME
DROP CONSTRAINT CONSTRAINT_NAME;

   Like      Feedback     drop a constraint  ALTER  DROP CONSTRAINT  DDL



Subscribe to Java News and Posts. Get latest updates and posts on Java from Buggybread.com
Enter your email address:
Delivered by FeedBurner