YiDbAbAu

1
2																																																																																																																																																																																														
3CREATE DATABASE hello
4drop database hello
5
6select name from master.sys.databases
7use hello
8create table tbl(
9id int primary key,
10firstname varchar(25),
11lastname varchar(25),
12c_address varchar(54),
13
14 
15);
16
17drop table tbl
18
19insert into tbl (id,firstname,lastname,c_address)
20values (1,'manis','dahal','ramkot'),(3,'kshitij','subedi','balajuheight'),
21(5,'kusal','guyz','east'),(6,'sallu','vai','coleznajikai'),(93,'nam','kho','khoi'),(23,'sakiyo','xaina','haha'),
22(56,'pp','pandey','ghar'),
23(89,'valkyri','sharma','balaju'),(80,'bijenwa','shrestha','basantpur')
24                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
25select * from tbl
26
27alter table tbl
28add phone varchar(45)
29
30alter table tbl
31drop column phone
32
33alter table tbl
34alter column phone int
35
36alter table tbl
37add primary key firstname
38
39create table tblstudent
40( s_id int,
41	s_firstname varchar(50),
42	s_lastname varchar(50),
43	s_address varchar(50),
44	s_phone varchar(50)
45
46	
47);
48
49drop table tblstudent
50
51insert into tblstudent (s_id,s_phone)
52values (12,65498),(12,4687),(23,6474964),(47,66984),(89,4653161)
53
54
55select * from tblstudent
56
57alter table tblstudent
58add s_gender varchar(50)
59
60insert into tblstudent (s_id,s_firstname,s_lastname,s_address,s_phone)
61values (1,'manis','dahal','ramkot',46576546),(3,'kshitij','subedi','balajuheight',465498644),
62(5,'kusal','guyz','east',4654646547),(6,'sallu','vai','coleznajikai',466346),(93,'nam','kho','khoi',13241654)
63
64alter table tblstudent
65alter column s_gender varchar(60)
66
67alter table tblstudent
68drop column s_gender
69
70alter table tblstudent
71alter column s_id int not null
72alter table tblstudent
73alter column s_phone varchar(10) not null
74
75alter table tblstudent
76add primary key (s_id,s_phone)
77																																																																																																																																																																																														
78create table if not exists sbcd