BNF notation of T-SQL

Question

Do you know where can I get the BNF (Backus Naur Form) notation for the latest version of T-SQL from. This is the microsoft version and I can't find anything for it. I found SQL2 The revised ISO standard here also called SQL92 but it seems to lack some features of microsoft's T-SQL

Literator

I don't believe that there is a published BNF for T-SQL. – Fume

Perhaps if you revised your question to why you wanted such a thing/what problem you were seeking to solve, it could be achieved without? – Fume

I'm developing something like intellisense for T-SQL (like RedGate's SQL Prompt). That's why I need the BNF notation in order to know what is the next available cosntruct/keyword. – Literator

Answer 1

Have you checked out this btw?

General Sql Parser

They have enginered the notation from the ground up....

Fidler

That is closed source which means: no BNF. – Colver

Answer 2

I developed TSql grammar for ANTLR 4 in EBNF form. Check it in official grammars repository. It based on msdn description.

Currently implemented syntax:

• Control of Flow (MSDN).
• Cursors (MSDN).

• Data manipulation language (DML):

  • Delete (MSDN).
  • Insert (MSDN).
  • Select (MSDN).
  • Update (MSDN).
• Expressions (MSDN).
• Predicates.
• Transactions (MSDN).

And another syntax. Check grammar and test files for more detail.

Metathesis

repository links are broken – Brownedoff

Thanks for the notice, I've fixed links. – Metathesis

Answer 3

I know this is an old question, but I just found this grammar file hosted on bitbucket that can be used with GOLD Parsing System.

Since you're looking for TSQL's BNF (I was too), and it doesn't really exist, this grammar is the next best thing IMO.

Gallivant

Answer 4

SQL-92 in BNF

SQL Server 2005 is based on SQL-92 with some SQL-99 features and Microsoft's T-SQL extensions. Best I have found currently.

Let me know if you find a more up to date one.....

Fidler

Microsoft uses brackets to quote identifiers. This is far away from SQL-92. – Colver