Database – What is TCL?

TCL (Transaction Control Language) statements are used to manage the changes made by DML statements. It allows statements to be grouped together into logical transactions. The main TCL commands are: COMMIT SAVEPOINT ROLLBACK SET TRANSACTION Related References Database Table Field Ordering Effective Practices Structured Query Language (SQL) Tuning What is DDL? What is DML? What … Continue reading Database – What is TCL?

What is DCL?

What is DCL (Data Control Language)? Data control language (DCL) is anything that is used for administrating access (permissions/security) to database content.  The main DCL commands are: Grant Revoke Related References Database Table Field Ordering Effective Practices Structured Query Language (SQL) Tuning What is DDL? What is DML?