DDL-Data Definition Language

--DDL : Data Definition Language :-

--New DataBase Creation :-

/*please ensure we are in master Database while creating new database.*/

USE MASTER

CREATE DATABASE KCTSHAN

USE KCTSHAN

-------------------------------------------------------------------------------------------------
--To Form the structure in a databas like Table creation ,database creation and alter these things.

--1. Create a new Table.

CREATE TABLE TblEmpDetails
(
    EmpId        VARCHAR(100),
    EmpName        NVARCHAR(100),
    Address        CHAR(300),
    City        VARCHAR(30),
    Country        VARCHAR(30),
    pincode        INT,
    DOB            DATETIME,
    DOJ            DATETIME,
    salary        MONEY,
    Gender        BIT,
    Age            INT,
    Height        NUMERIC(5,2)
)
GO

--View the Created Table Structure :

sp_help TblEmpDetails
               
--View the Data from the table:

SELECT * FROM TblEmpDetails1

------------------------------------------------------------------------------
--ALTERING A TABLE:- ADD/ALTER/DROP

ALTER TABLE TblEmpDetails ADD BranchCode VARCHAR(100),BracnhName VARCHAR(100)

ALTER TABLE TblEmpDetails ALTER COLUMN BranchCode CHAR(30)

ALTER TABLE TblEmpDetails DROP COLUMN BracnhName

DROP TABLE TblEmpDetails

------------------------------------------------------------------------------
--Deleting a DataBase:-

USE Master

DROP DATABASE KCTSHAN

------------------------------------------------------------------------------