Skip to content

RESUMABLE in ALTER TABLE (Transact-SQL) reports not valid option #125

@naveennaik1

Description

@naveennaik1

Version - 170.28.0

The following query mentioned in ALTER TABLE (Transact-SQL) reports the following error while parsing using TSql160Parser . Tried it with TSql160Parser, as well as 150 and 140, just to make sure.

Error : Option 'RESUMABLE' is not a valid index option in 'ALTER TABLE' statement.

Steps to reproduce

        static void Main(string[] args)
        {
            var script = @"
ALTER TABLE table1
ADD CONSTRAINT PK_Constrain PRIMARY KEY CLUSTERED (a)
WITH (ONLINE = ON, MAXDOP = 2, RESUMABLE = ON, MAX_DURATION = 240);
";

            var parser = new TSql160Parser(true, 0);
            var fragment = parser.Parse(new StringReader(script), out var parseErrors);

            if (parseErrors.Count > 0)
            {
                Console.WriteLine(parseErrors[0].Message);
            }
        }

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions