SQL CREATE Keyword

 The CREATE keyword in SQL is used to create database objects like tables, views, indexes, or schemas. Below are examples of how to use the CREATE keyword for different database objects:

1. Create Table

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

Example:

CREATE TABLE Employees (
    EmployeeID INT PRIMARY KEY,
    FirstName VARCHAR(50),
    LastName VARCHAR(50),
    HireDate DATE
);

2. Create Database

CREATE DATABASE database_name;

Example:

CREATE DATABASE CompanyDB;

3. Create View

CREATE VIEW view_name AS
SELECT column1, column2, ...
FROM table_name
WHERE condition;

Example:

CREATE VIEW ActiveEmployees AS
SELECT EmployeeID, FirstName, LastName
FROM Employees
WHERE HireDate > '2020-01-01';

4. Create Index

CREATE INDEX index_name
ON table_name (column1, column2, ...);

Example:

CREATE INDEX idx_employee_lastname
ON Employees (LastName);

5. Create Schema

CREATE SCHEMA schema_name;

Example:

CREATE SCHEMA HR;

The CREATE keyword is a crucial part of SQL for defining and managing the structure of databases and their elements.