Creating Database and Table

CREATE DATABASE VINODMAURYA /* Create Database*/

USE VINODMAURYA /*Use Database*/

CREATE TABLE EMPLOYEE /* Create table*/
(ID int, Name varchar(10), Salary varchar(10), City varchar(10))

select*from EMPLOYEE /*Select Record from Table*/

insert into EMPLOYEE /* Insert Record into table*/
(ID,Name,Salary,City)
values('1','Vinod','30000','Mumbai')

delete employee /* Delete Table Record from table*/
truncate table employee /* Truncate table record from table*/

alter table employee /* Add column in table*/
add Mobile varchar(11)

alter table employee /* Remove column from table*/
drop column Mobile

alter table employee /* Change datatype of column */
alter column Name varchar(10)

alter database VINODMAURYA /*Rename database name*/
modify name=VIJAYMAURYA