What are the challenges you face when working across database platforms? Take the survey
Options

Bug With Fillfactor

Hi !

The following syntax will successfully parsed but SQLPrompt will raise an error.

ALTER TABLE one_side ADD CONSTRAINT PKCL_one_side_col1 PRIMARY KEY (col1)
WITH FILLFACTOR = 100;
GO

The official syntax includes FillFactor in square brackets, but SQLPrompt suggests FillFactor without these brackets.

ALTER TABLE one_side ADD CONSTRAINT PKCL_one_side_col1 PRIMARY KEY (col1)
WITH (FILLFACTOR = 100);
GO

Therefore, either remove "FillFactor without brackets" from the proposal, or make sure SQLPrompt does not throw an error if brackets are not used.

Thanks!

Torsten
MVP

Answers

Sign In or Register to comment.