SQL Server FileTable 유용한 함수들 Part 3

#Part.3

SQL Server FileTable 유용한 함수들

Windows API 를 이용해서 해당 함수들을 사용할 수 있다.

SELECT FileTableRootPath('FileServers') AS FileTableRootPathLong;

GO

SELECT FileTableRootPath() as FileTableRootPath, file_stream.GetFileNamespacePath()

FROM [dbo].FileServers;

GO

SELECT GetPathLocator('\\SQL2014MIRA\MSSQLSERVER\FileTableShare\UploadFS');

GO

 

FileTable 사용여부 확인하기

SELECT * FROM sys.filetables;

GO

SELECT name, type, type_desc, create_date, is_filetable, durability_desc

FROM sys.tables WHERE is_filetable = 1;

GO

 

하위 디렉토리 생성하기

-- Crate Sub Folders

INSERT INTO dbo.FileServers(name,is_directory) values('Whitepapers',1)

INSERT INTO dbo.FileServers(name,is_directory) values('Multimedia',1)

GO

SELECT FileTableRootPath() as FileTableRootPath, file_stream.GetFileNamespacePath(), *

FROM [dbo].FileServers;

GO