SQL COMMANDS
TCL COMMANDS
- COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
DDL Commands
- CREATE - DROP - ALTER - TRUNCATE - COMMENT - RENAME
DCL COMMANDS
- GRANT - REVOKE
DML COMMANDS
- INSERT - UPDATE - DELETE
DQL COMMAND
- SELECT
5 SQL Commands
1. DDL 2. DQL 3. DML 4. DCL 5. TCL
DCL
Data Control Language
DDL
Data Definition Language
DML
Data Manipulation Language
DQL
Data Query Language
SQL
Database Language by the use of which we can perform certain operations on existing database and also we can use this language to create a database
GRANT
Gives user's access privileges to database.
ROLLBACK
Rollbacks a transaction in case of any error occurs.
SQL
Structures Query Language
TCL
Transaction Control Language
COMMENT
add comments to the data dictionary
COMMIT
commits a transaction
DDL
deals with descriptions of the database schema and is used to create and modify the structure of database objects in the database
TCL
deals with transaction within the database.
DQL
get some schema relation based on the query pass to it
DCL
includes commands such as GRANT and REVOKE deals with the rights, permissions and other controls of the database system
RENAME
rename an object existing in the database.
savepoint
set a savepoint within a transaction
set transaction
specify characteristic for the transaction.
DQL
used for performing queries on the data within schema objects
CREATE
used to create the database or its objects (like table, index, function, views, store procedure and triggers)
DDL
used to define the database schema
DROP
used to delete objects from the database.
DELETE
used to delete records from a database table.
INSERT
used to insert data into a table
ALTER
used to modify the structure of the database
TRUNCATE
used to remove all records from a table, including all spaces allocated for the records are removed.
select
used to retrieve data from a database.
UPDATE
used to update existing data within a table
SQL
uses certain commands like Create, Drop, Insert etc. to carry out the required task.
DML
with the manipulation of data present in the database belong to DML and this includes most of the SQL statement
REVOKE
withdraw user's access privileges given by using GRANT command
