DDL,DML,DCL区别
来源:百度文库 编辑:神马文学网 时间:2024/07/05 21:49:16
What are the difference between DDL, DML and DCL commands?
DDL is Data Definition Language statements. Some examples:- CREATE - to create objects in the database
- ALTER - alters the structure of the database
- DROP - delete objects from the database
- TRUNCATE - remove all records from a table, including all spaces allocated for the records are removed
- COMMENT - add comments to the data dictionary
- GRANT - gives user's access privileges to database
- REVOKE - withdraw access privileges given with the GRANT command
DML is Data Manipulation Language statements. Some examples:
- SELECT - retrieve data from the a database
- INSERT - insert data into a table
- UPDATE - updates existing data within a table
- DELETE - deletes all records from a table, the space for the records remain
- CALL - call a PL/SQL or Java subprogram
- EXPLAIN PLAN - explain access path to data
- LOCK TABLE - control concurrency
DCL is Data Control Language statements. Some examples:
- COMMIT - save work done
- SAVEPOINT - identify a point in a transaction to which you can later roll back
- ROLLBACK - restore database to original since the last COMMIT
- SET TRANSACTION - Change transaction options like what rollback segment to use
DDL,DML,DCL区别
Spotlight on DML | Event Recap: How Technolog...
db2look - DB2 Statistics and DDL Extraction Tool
Sql Server2005 Transact-SQL 新兵器学习总结之-DDL触发器 -...
如何根据当前MDB中的表生成对应的JET SQL DDL “CREATE TABLE”语句...
Oralce中,DDL语句为什么不能回滚 - 飘然的专栏 - CSDN博客
DCL-48连续走行捣固车_业务介绍_工业制造_大型养路机械_中国铁建股份有限公司
区别【音画】
男女区别
男女区别
诗 区别
区别男女
中西医区别
男女区别
RM,RMVB的区别
区别科学与伪科学
Java .Net 的区别
男女生宿舍的区别
区别三类心脏病
中西医的区别
Mb and MB 区别
AMD CPU的区别
人和动物有区别
肉眼看不出区别