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?

Database – What is DDL?

SQL (Structured Query Language) What is DDL (Data Definition Language)? DDL (Data Definition Language), are the statements used to manage tables, schemas, domains, indexes, views, and privileges.  The the major actions performed by DDL commands are: create, alter, drop, grant, and revoke. Related References What is DCL?What is DML?Database Table Field Ordering Effective PracticesStructured Query Language … Continue reading Database – What is DDL?

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?