CREATE Command in SQL

The CREATE command is a DDL (Data Definition Language) command used to create database objects such as tables, views, indexes, and databases.

Syntax

Create a Table

CREATE TABLE table_name (
    column1 datatype,
    column2 datatype,
    column3 datatype
);

Example 1: Create Student Table

CREATE TABLE Student (
    StudentID NUMBER(5),
    Name VARCHAR2(50),
    City VARCHAR2(30),
    Marks NUMBER(5,2)
);

Table Structure

Example 2: Create Employee Table

CREATE TABLE Employee (
    EmpID NUMBER(5),
    EmpName VARCHAR2(50),
    Salary NUMBER(8,2),
    JoinDate DATE
);

Create Table with Constraints

CREATE TABLE Student (
    StudentID NUMBER(5) PRIMARY KEY,
    Name VARCHAR2(50) NOT NULL,
    Email VARCHAR2(100) UNIQUE,
    City VARCHAR2(30)
);

Constraints Used

Other CREATE Commands

Create View

CREATE VIEW Student_View AS
SELECT StudentID, Name
FROM Student;

Create Index

CREATE INDEX idx_name
ON Student(Name);

Advantages of CREATE Command

• Creates new database objects.
• Defines table structure.
• Supports constraints for data integrity.
• Organizes data efficiently.

Summary

The CREATE command is used to create database objects. The most common use is:

CREATE TABLE table_name (
    column_name datatype,
    column_name datatype
);

It is a DDL command because it defines the structure of database objects.