Easy learning with example program codes

What are various DDL commands in SQL?

1. CREATE – It is used to create database objects like table, view etc.
2. ALTER – It is used to alter the structure of the existing database object.
3. DROP – It is used to delete the existing objects from the database.
4. TRUNCATE – It remove all records from a table, including all spaces allocated for the records will be removed.
5. RENAME – It is used to rename an existing database object.

Related topics

Please follow and like us:
Posted in SQL   

Copyright © 2019 CodesJava Protection Status SiteMap Reference: Java Wiki