Shulou(Shulou.com)05/31 Report--

This article introduces how to find the file according to the partition table name in SQL Server, the content is very detailed, interested friends can refer to, hope to be helpful to you.

SELECT ps.name AS PSName, dds.destination_idAS PartitionNumber, fg.name AS FileGroupName,fg.name, t.name F.name as filename FROM ((sys.tables AS t INNER JOIN sys.indexes AS i ON (t.object_id = i.object_id)) INNER JOIN sys.partition_schemes AS ps ON (i.data_space_id = ps.data_space_id)) INNER JOIN sys.destination_data_spacesAS dds ON (ps.data_space_id = dds.partition_scheme_id)) INNER JOIN sys.filegroups AS fg ONdds. Data_space_id = fg.data_space_id innerjoin sys.database_files f on f.data_space_id = fg.data_space_id where t.nameboy salesOrder.That 's all about how to find the file in SQL Server based on the partition table name I hope the above content can be of some help to you and learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.