-
-
Notifications
You must be signed in to change notification settings - Fork 873
Closed
Labels
enhancementNew feature or requestNew feature or requestt-sqlIssues related to the T-SQL/TSQL/Transact SQL dialectIssues related to the T-SQL/TSQL/Transact SQL dialect
Description
Search before asking
- I searched the issues and found no similar issues.
Description
For the tsql dialect the following statement gives a parsing error:
ALTER TABLE #Persons DROP CONSTRAINT IF EXISTS PK_Person;
This is however valid sql code as mentioned in https://learn.microsoft.com/en-us/azure/databricks/sql/language-manual/sql-ref-syntax-ddl-alter-table-drop-constraint
Use case
ALTER TABLE #Persons DROP CONSTRAINT IF EXISTS PK_Person;
should not give a parsing error
Dialect
Tsql
Are you willing to work on and submit a PR to address the issue?
- Yes I am willing to submit a PR!
Code of Conduct
- I agree to follow this project's Code of Conduct
Metadata
Metadata
Assignees
Labels
enhancementNew feature or requestNew feature or requestt-sqlIssues related to the T-SQL/TSQL/Transact SQL dialectIssues related to the T-SQL/TSQL/Transact SQL dialect