Data control language
A data control language (DCL) is a syntax similar to a computer programming language used to control access to data stored in a database (authorization). In particular, it is a component of Structured Query Language (SQL). Data Control Language is one of the logical group in SQL Commands. SQL is the standard language for relational database management systems. SQL statements are used to perform tasks such as insert data to a database, delete or update data in a database, or retrieve data from a database. Examples of DCL commands include:
- Abstraction100002137
- Code106355894
- CodingSystem106353757
- CommandLanguage106899446
- Communication100033020
- DatabaseManagementSystem106588785
- Language106282651
- software
- Software106566077
- SourceLanguage106283912
- WikicatDatabaseManagementSystems
- WikicatQueryLanguages
- Writing106359877
- WrittenCommunication106349220
- Comment
- enA data control language (DCL) is a syntax similar to a computer programming language used to control access to data stored in a database (authorization). In particular, it is a component of Structured Query Language (SQL). Data Control Language is one of the logical group in SQL Commands. SQL is the standard language for relational database management systems. SQL statements are used to perform tasks such as insert data to a database, delete or update data in a database, or retrieve data from a database. Examples of DCL commands include:
- Has abstract
- enA data control language (DCL) is a syntax similar to a computer programming language used to control access to data stored in a database (authorization). In particular, it is a component of Structured Query Language (SQL). Data Control Language is one of the logical group in SQL Commands. SQL is the standard language for relational database management systems. SQL statements are used to perform tasks such as insert data to a database, delete or update data in a database, or retrieve data from a database. Though database systems use SQL, they also have their own additional proprietary extensions that are usually only used on their system. For Example Microsoft SQL server uses Transact-SQL (T-SQL) which is an extension of SQL. Similarly Oracle uses PL-SQL which is their proprietary extension for them only. However, the standard SQL commands such as "Select", "Insert", "Update", "Delete", "Create", and "Drop" can be used to accomplish almost everything that one needs to do with a database. Examples of DCL commands include: * GRANT to allow specified users to perform specified tasks. * REVOKE to remove the user accessibility to database object. The operations for which privileges may be granted to or revoked from a user or role apply to both the Data definition language (DDL) and the Data manipulation language (DML), and may include , SELECT, INSERT, UPDATE, DELETE, , and .
- Hypernym
- Syntax
- Is primary topic of
- Data control language
- Label
- enData control language
- Link from a Wikipage to an external page
- dev.mysql.com/doc/refman/8.0/en/account-management-statements.html
- blog.ansi.org/2018/10/sql-standard-iso-iec-9075-2016-ansi-x3-135/
- www.oracle.com/in/database/
- docs.oracle.com/cd/B28359_01/server.111/b28286/statements_1001.htm%23SQLRF30001
- Link from a Wikipage to another Wikipage
- Authorization
- Category:Data modeling
- Category:SQL
- Connect (SQL)
- Database transaction
- Data definition language
- Data manipulation language
- Data query language
- Delete (SQL)
- Execute (SQL)
- File system permissions
- Grant (SQL)
- Insert (SQL)
- MySQL server
- Oracle Database
- PostgreSQL
- Programming language
- Revoke (SQL)
- Select (SQL)
- SQLite
- Structured Query Language
- Usage (SQL)
- SameAs
- 4nmEK
- Data control language
- Data control language
- Data Control Language
- Data Control Language
- Data Control Language
- DCL
- DCL
- Langage de contrôle de données
- Lenguaje de control de datos
- Linguagem de controle de dados
- m.04f0sf
- Q604737
- لغة التحكم بالبيانات
- データ制御言語
- 資料控制語言
- 데이터 제어 언어
- Subject
- Category:Data modeling
- Category:SQL
- WasDerivedFrom
- Data control language?oldid=1068331726&ns=0
- WikiPageLength
- 8174
- Wikipage page ID
- 1180732
- Wikipage revision ID
- 1068331726
- WikiPageUsesTemplate
- Template:Databases
- Template:More citations needed
- Template:Reflist
- Template:Short description
- Template:Sxhl