SQL basics(Data Definition Language), Sql Server

SQL basics(Data Definition Language)

Language: Layout:

--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;

View schema
Absolute service time: 0,17 sec

Error(s), warning(s):

Invalid object name 'friends'.

	sql server version
1	Microsoft SQL Server 2014 - 12.0.2000.8 (Intel X86) Feb 20 2014 19:20:46 Copyright (c) Microsoft Corporation Express Edition on Windows NT 6.3 <X64> (Build 9600: ) (WOW64) (Hypervisor)

	ID	NAME	Birthday
1	1	Jane Doe	May 19th 1993
2	2	Sabir Patel	December 11th 1995
3	3	Imran Mansuri	October 21 1995
4	4	Rizwan Shaikh	July 22 1995

	ID	NAME	Birthday
1	1	Jane Smith	May 19th 1993
2	2	Sabir Patel	December 11th 1995
3	3	Imran Mansuri	October 21 1995
4	4	Rizwan Shaikh	July 22 1995

	ID	NAME	Birthday	Email
1	1	Jane Smith	May 19th 1993	NULL
2	2	Sabir Patel	December 11th 1995	NULL
3	3	Imran Mansuri	October 21 1995	NULL
4	4	Rizwan Shaikh	July 22 1995	NULL

	ID	NAME	Birthday	Email
1	2	Sabir Patel	December 11th 1995	[email protected]
2	3	Imran Mansuri	October 21 1995	[email protected]
3	4	Rizwan Shaikh	July 22 1995	[email protected]

	ID	NAME	Birthday	Email	deathday
1	2	Sabir Patel	December 11th 1995	[email protected]	NULL
2	3	Imran Mansuri	October 21 1995	[email protected]	NULL
3	4	Rizwan Shaikh	July 22 1995	[email protected]	NULL