We have listed out the examples in Azure Synapse Dedicated SQL Pool that are currently not supported in Microsoft SQL Parser ( TSql160Parser ) Version - 170.28.0
static void Main(string[] args)
{
var script = @"<EXAMPLE_SCRIPT>";
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);
}
}
We have listed out the examples in Azure Synapse Dedicated SQL Pool that are currently not supported in
Microsoft SQL Parser ( TSql160Parser )Version - 170.28.0Microsoft documentation references :
Data Definition Language (DDL) statements
Option 'RESUMABLE' is not a valid index option in 'ALTER TABLE' statement.Incorrect syntax near 'MAXSIZE'.Incorrect syntax near 'materialized'.Incorrect syntax near 'ON'.Incorrect syntax near 'FORMAT_OPTIONS'.Expected but did not find a closing quotation mark after the character string 't NULLIncorrect syntax near 'DATABASE'.Query statements
Incorrect syntax near 'FORMAT_OPTIONS'.Incorrect syntax near 'REDUCE'.Expected BYPASS but encountered FORCE instead.Security statements
Incorrect syntax near '='.Incorrect syntax near '='.Incorrect syntax near 'ON'.T-SQL language elements for dedicated SQL pool in Azure Synapse Analytics
Incorrect syntax near 'AUTOCOMMIT'.Incorrect syntax near 'DIAGNOSTICS'.Steps to reproduce