dropLearning Curve- Perfect Tutorial for the beginers | Learning Curve- Perfect Tutorial for the beginers

Difference between TRUNCATE,DELETE and DROP commands

1)DELETE-Delete command is using to remove a rows from a table. “Where” clause is used to remove some rows. if no “where” condition specified all rows will be removed. After performing a DELETE operation you need to “commit” or “Rollback” the transaction to make the change permanent or undo it. 2)TRUNCATE- “truncate” removes all rows… Read More »

Data Definition Language-DDL

These are used to define database structure or schema Examles as below 1.CREATE- create objects in the database 2.ALTER- alters the structure of the database 3.DROP-delete the objects from the database 4.TRUNCATE-remove all the records from the database including spaces allocated for the records are removed. 5.COMMENT-add comments to the data dictionary 6.RENAME-rename an object.