SQL basics(Data Definition Language), Sql Server

SQL basics(Data Definition Language)

--Sql Server 2014 Express Edition
--Batches are separated by 'go'

select @@version as 'sql server version'

create table friends
(ID INTEGER,
NAME TEXT,
Birthday TEXT);

insert into friends values(1,'Jane Doe','May 19th 1993')
insert into friends values(2,'Sabir Patel','December 11th 1995')
insert into friends values(3,'Imran Mansuri','October 21 1995')
insert into friends values(4,'Rizwan Shaikh','July 22 1995');

/*Look up table friends*/
select * from friends;

/*updating table friends*/
update friends 
set name = 'Jane Smith'
where id = 1;

select * from friends;

/*adding column*/
alter table friends 
ADD 
Email TEXT;

select * from friends;

/*updating table friends*/
update friends
set email = 'jdoe@example.com'
where id =1;

/*updating table friends*/
update friends
set email = 'sabir@example.com'
where id = 2;

/*updating table friends*/
update friends
set email = 'imran@example.com'
where id = 3;

/*updating table friends*/
update friends
set email = 'rizwan@example.com'
where id = 4;

/*deleting a roe from friends*/
delete  from friends where id = 1;

select * from friends;

/*adding a column*/
alter table friends
add  deathday text;

select * from friends;

/*droping the entire table*/
drop table friends;

/*this shows table has been dropped*/
select * from friends;


run \| edit \| history \| help	0