SQL Statements?

 --SELECT,INSERT,UPDATE,DELETE,ALTER,DROP,TRUNCATE,CREATE,USE,SHOW

--USE [LiveSession]

--SELECT *FROM EMPLOYEES

--SELECT *FROM EMPLOYEESALARY

--INSERT INTO EMPLOYEES([NAME],ID,IsActive,AGE) VALUES('HELLO',5,0,60)

--UPDATE EMPLOYEES SET [NAME] = 'ABC',AGE=1 WHERE ID=5

--DELETE EMPLOYEES WHERE ID=5

--DELETE EMPLOYEESALARY

--ALTER TABLE EMPLOYEESALARY ADD T INT

--ALTER TABLE EMPLOYEESALARY ALTER COLUMN T BIT  -- ALT+F1

--TRUNCATE VS DROP VS DELETE

TRUNCATE TABLE EMPLOYEESALARY -- IDENTITY(1,1)

DROP TABLE EMPLOYEESALARY