New answers tagged filegroups
Only PRIMARY KEY and UNIQUE constraints have an optional ON filegroup clause. That's because these constraints always create an automatic index to support their uniqueness. The filegroup clause decides where this index will live, so in your case it should always be 'app_index'. You cannot specify a filegroup for other constraints such as FOREIGN KEY, CHECK ...
Top 50 recent answers are included