dcl vs ddl vs dql vs dml code example
Example: dml vs ddl sql
DML commands actions can be stored
DLL command actions can't be stored.
DML = SELECT, INSERT, UPDATE, DELETE, MERGE
DDL = CREATE, ALTER, TRUNCATE, DROP TABLE, RENAME
DML commands actions can be stored
DLL command actions can't be stored.
DML = SELECT, INSERT, UPDATE, DELETE, MERGE
DDL = CREATE, ALTER, TRUNCATE, DROP TABLE, RENAME