SQL Server 2012: Script to find all System Objects related to File Table

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 :

Anvesh Patel

Leave a Reply

Be the First to Comment!

Notify of