The alter table statement [dbo] [Area] alter the column name nvarchar (200)

Statistics' _dta_stat_1438628168_2_3_4 'depends on the column' name ',
Message 5074, level 16, state 1, line 1
Index 'NonClusteredIndex - parentCode' depends on the column 'name',
Message 5074, level 16, state 1, line 1
Statistics' _dta_stat_1438628168_2_4_1_3_5_6_7_8 'depends on the column' name ',
Message 4922, level 16, state 9, line 1
Due to one or more objects access this COLUMN, the ALTER TABLE ALTER the COLUMN name fails,
Please help me solve the

CodePudding user response:

Field with the index, to remove index, to modify its fixed length,
The index name: NonClusteredIndex - parentCode

CodePudding user response:

The index is solved the statistical information how

CodePudding user response:

DROP STATISTICS