SQLQuery1.sql

CREATE DATABASE JAN2026
USE JAN2026
--TYPES OF SQL LANGUAGE
--DDL - STRUCUTRE DEFINE 
--DML - MODIFY TABLE /DATABASE  (INSERT ,UPDATE ,DELETE)
--DQL - DATA QUERY LANGUAGE .  SELECT 
--TCL - TRANSACTION QUERY LANGUAGE 
--COMMIT , ROLBACK AND SAVEPOINT 
Select 4+4 as Addition 
Select 'Hello ' + '  Patel ' As Fullname 
Select GETDATE()
Select SYSTEM_USER
-- Drop database JAN2026 for dropping table 

Alter database JAN2026
MODIFY NAME = JANUARY2026

--TO CREATE A TABLE IN DATABASE 
--Create Table <Name>
-- (Coll name <datatype> 

Create Table Employee
(EID INT, Ename Varchar(20) ,
Eage INT,
Esalary Money)

Select * from Employee

sp_rename 'Employee' , 'EMP'
--SP_RENAME 'Table
sp_rename 'EMP.EID' , 'EMPID'

Select * from Emp

-- to displays all Databases in server .
Select name, create_date
from sys.databases 

-- to displays all tables  in databases .
Select name
from sys.tables  

-- to drop a table 
--drop table <tablename>
--drop table Employee;