SQL

/*select * from spt_values where number>10*/

/*
create table student
(
st_kodi int primary key not null,
saxeli varchar(20) not null,
gvari varchar(30) not null,
strip int check(strip between 0 and 150),
city varchar(10) null,
tel varchar(20),
fakulty_kodi int,
date_of_birth datetime
)

create table university
(
uni_kodi int primary key,
un_name varchar(20),
un_address varchar(30)
)
*/
/*
insert into university(uni_kodi, un_name)
values
(111, 'tsu'),
(222, 'esm'),
(333, 'tsmu'),
(444, 'gtu'),
(555, 'gau'),
(666, 'free_uni')
*/

/*exec sp_rename 'student.fakulty_kodi', 'fakulty', 'column'*/

ALTER TABLE student
ALTER COLUMN fakulty VARCHAR(20)

ALTER TABLE student
ADD
CONSTRAINT df_city DEFAULT 'tbilisi' FOR city

ALTER TABLE student
DROP COLUMN date_of_birth