ddl sql commands code example

Example 1: dml commands

CREATE TABLE TABLE_NAME (COLUMN_NAME DATATYPES[,....]);

Example 2: dml commands

Create database university;
Create table students;
Create view for_students;

Example 3: 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

Tags:

Sql Example

Related