· 6 years ago · Dec 15, 2019, 07:44 PM
1use master;
2go
3
4drop database if exists lab10;
5go
6
7create database lab10;
8go
9
10use lab10;
11go
12
13create table VisaCenter
14(
15 VisaCenterName varchar(30) primary key not null,
16 ApplicationCount int default 0
17)
18go
19
20insert into VisaCenter(VisaCenterName, ApplicationCount)
21values ('VisaCenter_1', 5);
22go