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

Question

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?

gbn · Accepted Answer · 2011-12-15T08:53:18.760

12

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

The option is here:

SSMS File group option

edited Dec 15 '11 at 08:53

answered Dec 15 '11 at 08:27

gbn

70,237
8
167
244

score 2 · Answer 2 · answered Jan 26 '17 at 15:43

2

This is a also a long standing bug because it also generates TEXTIMAGE_ON when running the script fails because that option is set when no appropriate text columns!

answered Jan 26 '17 at 15:43

Dave

175
7

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

2 Answers2