MOVING TABLE FROM PRIMARY TO SECONDARY FILEGROUP

MOVING TABLE FROM PRIMARY TO SECONDARY FILEGROUP

CLUSTERED TABLE:

Create a database here in our discussion we consider the database name as ‘test1’

Create a secondary filegroup.

Create the file on the secondary filegroup.

Creating a table on primary.

Checking where the table is created.

With the help of “index_name” we can move the table from primary to secondary filegroup.

Checking where the change happened successfully or not.

MOVING NON CLUSTERED TABLE FROM PRIMARY TO SECONDARY FILEGROUP

Creating a database ‘data1’ on primary:

Creating a secondary filegroup with name fg1

Creating table:

Information about the table: we don’t have “index_name” information.

Creating a file on secondary file group:

Creating indexes for the table:

Information about the table: Here we have information about the “index_name”.

Creating index on table to move the table to secondary filegroup.

Information about the table which shows that, the table is moved to secondary filegroup.