TABLE  FileGroupMap

For 'big' databases, maps big tables to their own file groups

In big databases we only put core objects in the primary file group. Other objects are grouped into separate file groups. For really big files, the indices are put in even different groups. This table is truncated in the Task databases.

nametypelengthunitucddescription
tableNamevarchar128  name of table or index
tableFileGroupvarchar100  name of filegroup
indexFileGroupvarchar100  name of the index filegroup
commentvarchar4000  explanation