Ddl Commands | Data Management Software | Sql

Please download to get full document.

View again

of 13
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Information Report
Category:

Documents

Published:

Views: 10 | Pages: 13

Extension: PDF | Download: 0

Share
Related documents
Description
Ddl Commands
Transcript
  SQL Commands (DDL & Constraints) SCSE/VITCC  Components of SQL ã Data Definition Language (DDL) ã Data Manipulation Language (DML) ã Transaction Control Language (TCL) ã Data Control Language (DCL)  ã Data Definition Language (DDL)  - These SQL commands are used for creating, modifying, and dropping the structure of database objects. The commands are CREATE, ALTER, DROP, RENAME, and TRUNCATE. ã Data Manipulation Language (DML)  - These SQL commands are used for storing, retrieving, modifying, and deleting data. These commands are SELECT, INSERT, UPDATE, and DELETE. ã Transaction Control Language (TCL)  - These SQL commands are used for managing changes affecting the data. These commands are COMMIT, ROLLBACK, and SAVEPOINT. ã Data Control Language (DCL)  - These SQL commands are used for providing security to database objects. These commands are GRANT and REVOKE.
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks