CODEWITHSUNDEEP
sqlms-accessgrammar
JacquesB
JacquesB

Reputation: 42669

A grammar for Access SQL

Does a grammar (like in EBNF or similar format) exist for MS Access SQL syntax? Like how TSQL syntax is documented with EBNF: https://learn.microsoft.com/en-us/sql/t-sql/queries/select-transact-sql?view=sql-server-2017.

I have only been able to find find tutorials with examples, but not a full grammar.

Upvotes: 0

Views: 207

Answers (1)

Erik A
Erik A

Reputation: 32642

You can find the full Access SQL reference here on MS Docs.

Note that some statements are exclusive to the SQL server compatible syntax (anything with the DECIMAL type and CHECK constraints), and this isn't properly described in the reference.

It isn't as extensive and well-written as the T-SQL stuff, but it's closest to what you're asking.

Upvotes: 5

Related Questions