ddl sql code example

Example 1: what is data definition language

DDL
1-It stands for Data Definition Language.
2-It is used to create database schema and can
be used to define some constraints as well.	
3-It basically defines the column (Attributes) of the table.	
4-It doesn’t have any further classification.
5-Basic command present in DDL are CREATE, DROP, RENAME, ALTER etc.
6-DDL does not use WHERE clause in its statement.

Example 2: dml commands

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

Example 3: dml commands

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