GitHub

alter-database-transact-sql-file-and-filegroup-options.md

When you move a full-text catalog, specify only the new path in the FILENAME clause. Do not specify the operating-system file name. For more information, see Move Database Files. For a FILESTREAM ...
GitHub

create-index-transact-sql.md

Because the clustered index contains all data in the table, creating a clustered index and using the ON partition_scheme_name or ON filegroup_name clause effectively moves the table from the filegroup ...