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.name='salesOrder'

发表评论

您的电子邮箱地址不会被公开。 必填项已用*标注