CREATE TABLE TEXTIMAGE_ON [PRIMARY] is redundant it there’s only one filegroup

filegroups

I've recently generated scripts for a legacy database, and discovered that most of the tables were created with TEXTIMAGE_ON [PRIMARY], but there's only one filegroup.

TEXTIMAGE_ON [PRIMARY] is redundant when there is only a single filegroup, correct?

Best Answer

Yes, this is redundant. By default, SSMS will script these

The option is here:

SSMS File group option