This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In this post, I am providing one TSQL script to find all list of system object which are related to particular File Table of SQL Server 2012.
When we create File Table, it is also required to file all related objects for it.
SQL Server 2012 also introduced one new system view sys.filetable_system_defined_objects to find all system objects which are related to File Table.
Below is a script using sys.filetable_system_defined_objects :
|
1 2 3 4 5 6 7 8 9 |
DECLARE @FileTableName VARCHAR(50) SET @FileTableName='dbo.tbl_MyFileTable' SELECT OBJECT_NAME(parent_object_id) AS FileTableName ,OBJECT_NAME(object_id) AS AllRelatedObjects FROM sys.filetable_system_defined_objects WHERE parent_object_id = object_id(@FileTableName) GO |
