J1jmFJNr

1USE master;
2GO
3IF DB_ID (N'Sales') IS NOT NULL
4DROP DATABASE Sales;
5GO
6-- execute the CREATE DATABASE statement
7CREATE DATABASE Sales
8ON ( NAME = Sales_dat, FILENAME =
9'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\salesdat.mdf',
10SIZE = 10, MAXSIZE = UNLIMITED, FILEGROWTH = 5% )
11LOG ON ( NAME = Sales_log, FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\salelog.ldf',
12SIZE = 5MB, MAXSIZE = 25MB, FILEGROWTH = 5MB );
13GO
14CREATE SCHEMA Sales;
15GO
16create table Sales.Products
17(
18	 ID INT PRIMARY KEY IDENTITY (1,1),
19	 name VARCHAR (50) NOT NULL,
20	 price int NOT NULL,
21);
22GO
23USE master
24GO
25
26ALTER DATABASE Sales  
27ADD FILEGROUP SalesFilegroup1;  
28GO  
29ALTER DATABASE Sales   
30ADD FILE   
31(  
32    NAME = Sales_dat_2,  
33    FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\Sales_dat2.ndf',  
34    SIZE = 10MB,  
35    MAXSIZE = 100MB,  
36    FILEGROWTH = 5%  
37),  
38(  
39    NAME = Sales_dat_3,  
40    FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\Sales_dat3.ndf',  
41    SIZE = 10MB,  
42    MAXSIZE = 100MB,  
43    FILEGROWTH = 5% 
44)  
45TO FILEGROUP SalesFilegroup1;  
46GO
47USE Sales
48GO
49IF NOT EXISTS (SELECT name FROM sys.filegroups WHERE is_default=1 AND name = N'SalesFilegroup1') ALTER DATABASE Sales MODIFY FILEGROUP SalesFilegroup1 DEFAULT
50GO
51create table Sales.Customers
52(
53	 ID INT PRIMARY KEY IDENTITY (1,1),
54	 firts_name VARCHAR (50) NOT NULL,
55	 second_name VARCHAR (50) NOT NULL,
56	 phone char (11) NOT NULL,
57);
58GO
59USE Sales
60GO
61IF NOT EXISTS (SELECT name FROM sys.filegroups WHERE is_default=1 AND name = N'PRIMARY') ALTER DATABASE Sales MODIFY FILEGROUP [PRIMARY] DEFAULT
62GO
63CREATE UNIQUE CLUSTERED INDEX Kek ON Sales.Customers  (ID, firts_name, second_name, phone) ON [primary]
64USE Sales
65GO
66ALTER DATABASE Sales  REMOVE FILE Sales_dat_2
67GO
68ALTER DATABASE Sales  REMOVE FILE Sales_dat_3
69GO
70ALTER DATABASE Sales REMOVE FILEGROUP SalesFilegroup1
71GO
72CREATE SCHEMA SalesNEW;
73GO
74ALTER SCHEMA SalesNEW TRANSFER Sales.Customers;
75GO
76INSERT INTO SalesNEW.Customers(firts_name)
77VALUES ('lala');
78GO
79use Sales
80DROP TABLE SalesNEW.Customers;
81DROP SCHEMA SalesNEW;