What is DDL DML DCL, SQL Server?

Data Definition Language (DDL):- are the SQL statements that define the database objects structure
Example:
CREATE
ALTER
DROP
TRUNCATE
COMMENT
RENAME

Data Manipulation Language (DML):- are the SQL statements that Manipulates with the data stored in the structure.
Example:
SELECT - retrieve data from the a database
INSERT - insert data into a table
UPDATE - updates existing data within a table
DELETE
MERGE
CALL
EXPLAIN PLAN
LOCK TABLE

Data Control Language (DCL):- statements to take care of the security and authorization.
DCL (Data Control Language) controls your DML and DDL statements so that your data
is protected and has consistency. COMITT and ROLLBACK are DCL control statements.
DCL guarantees ACID fundamentals of a transaction
Examples:
GRANT
REVOKE

Brain Food :- Stored Procedure offers business logic with a single point of control to ensure that the business rules are correctly enforced.

1 comments:

Post a Comment