mpUK5Xww

1use master;
2go
3
4
5drop database if exists lab5
6go
7
8
9create database lab5
10    on (name = VisaCenterData, filename = '/home/max/DataBases/lab5/VisaCenterData.mdf', size = 10 mb, maxsize = unlimited, filegrowth = 10%)
11    log on ( name = VisaCenterLog, filename = '/home/max/DataBases/lab5/VisaCenterLog.ldf', size = 5 mb, maxsize = unlimited, filegrowth = 10%);
12go
13
14
15use lab5;
16go
17
18
19create table VisaCenter
20(
21    VisaCenterName char(20) not null primary key,
22    Address        char(30) not null,
23    WorkTime       time     not null
24);
25go
26
27
28alter database lab5
29    add filegroup NewGroup;
30go
31
32
33alter database lab5
34    add file (
35        name = Something,
36        filename = '/home/max/DataBases/lab5/Something.ndf',
37        size = 5 mb,
38        maxsize = 20 mb,
39        filegrowth = 10%
40        )
41        to filegroup NewGroup;
42go
43
44
45alter database lab5
46    modify filegroup NewGroup default;
47go
48
49
50create table Embassy
51(
52    Country     char(20) not null,
53    Address     char(30) not null,
54    PhoneNumber char(15) not null
55);
56go
57
58
59/*alter table Embassy
60    drop constraint PK__Embassy__067B30084B51B68D;
61go*/
62
63create clustered index Embassy
64    on dbo.Embassy (Country)
65    on [Primary];
66go
67
68
69alter database lab5
70    modify filegroup [Primary] default;
71go
72
73alter database lab5
74    remove file Something;
75go
76
77alter database lab5
78    remove filegroup NewGroup;
79go
80
81
82create schema VC;
83go
84
85alter schema VC
86    transfer VisaCenter;
87go
88
89alter schema dbo
90    transfer VC.VisaCenter;
91go
92
93drop schema VC;
94go