none
SQL SERVER 2008如何查询一个数据文件上有哪些表? RRS feed

答案

  • Take look at this link: https://blog.sqlauthority.com/2009/06/01/sql-server-list-all-objects-created-on-all-filegroups-in-database/, it has code to list objects in each file group. SQL spreads objects to all files in each file group.
    2019年3月27日 14:11

全部回复

  • How many file groups does the db have? If has only one file group with multiple files, sql will spread tables to all files in that file group. 

    2019年3月26日 13:53
  • How many file groups does the db have? If has only one file group with multiple files, sql will spread tables to all files in that file group. 


    两个文件组,每个文件组两个文件
    2019年3月27日 1:16
  • Take look at this link: https://blog.sqlauthority.com/2009/06/01/sql-server-list-all-objects-created-on-all-filegroups-in-database/, it has code to list objects in each file group. SQL spreads objects to all files in each file group.
    2019年3月27日 14:11
  • 表存储在文件组,文件组可能包含多个文件,所以表和文件没有一对一的关系
    2019年3月28日 0:54