-
Notifications
You must be signed in to change notification settings - Fork 5
/
Chapter 08-extras - probably delete.sql
52 lines (43 loc) · 1.28 KB
/
Chapter 08-extras - probably delete.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
CREATE DATABASE FileStorageDemo; --uses basic defaults from model databases
GO
USE FileStorageDemo;
GO
CREATE TABLE dbo.FileTableTest2 AS FILETABLE
WITH (
FILETABLE_DIRECTORY = 'FileTableTest',
FILETABLE_COLLATE_FILENAME = database_default
)
GO
Msg 1969, Level 16, State 1, Line 1
Default FILESTREAM filegroup is not available in database 'FileStorageDemo'.
--will cover more in the structures chapter
ALTER DATABASE FileStorageDemo ADD
FILEGROUP FilestreamData CONTAINS FILESTREAM;
CREATE TABLE dbo.FileTableTest2 AS FILETABLE
WITH (
FILETABLE_DIRECTORY = 'FileTableTest',
FILETABLE_COLLATE_FILENAME = database_default
)
GO
Msg 1719, Level 16, State 1, Line 1
FILESTREAM data cannot be placed on an empty filegroup.
Go
ALTER DATABASE FileStorageDemo ADD FILE (
NAME = FilestreamDataFile1,
FILENAME = 'c:\sql\filestream')
TO FILEGROUP FilestreamData;
GO
CREATE TABLE dbo.FileTableTest2 AS FILETABLE
WITH (
FILETABLE_DIRECTORY = 'FileTableTest',
FILETABLE_COLLATE_FILENAME = database_default
)
GO
ALTER DATABASE [FileStorageDemo] SET FILESTREAM( DIRECTORY_NAME = N'FileStorageDemo' ) WITH NO_WAIT
GO
CREATE TABLE dbo.FileTableTest2 AS FILETABLE
WITH (
FILETABLE_DIRECTORY = 'FileTableTest',
FILETABLE_COLLATE_FILENAME = database_default
)
GO