# Is there a robust DREMIO SQL Reference available?

**URL:** <https://community.dremio.com/t/is-there-a-robust-dremio-sql-reference-available/1893>\
**Category:** Uncategorized\
**Created:** [September 21, 2018, 5:41am UTC](https://community.dremio.com/t/is-there-a-robust-dremio-sql-reference-available/1893 "2018-09-21T05:41:52Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![pba](https://avatars.discourse-cdn.com/v4/letter/p/278dde/32.png) [@pba](https://community.dremio.com/u/pba)\
**Post date:** [September 21, 2018, 5:41am UTC](https://community.dremio.com/t/is-there-a-robust-dremio-sql-reference-available/1893/1 "2018-09-21T05:41:52Z")

</div>

I’m trying some queries in Dremio to build a good virtual source from a SQL Server Dataset.  
I am getting invalid syntax when trying to set a variable. I can not find anything that shows all the valid SQL language commands in Dremio. I want to find the equivalent to DECLARE in T-SQL but can not find reference material to help me do this.

Also, I am getting some validation errors when I try different window functions.

Can anyone point me to a robust language reference for Dremio SQL?

Thanks!

---

<div class="post-metadata">

**Author:** ![firefly707](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/firefly707/32/646_2.png) [@firefly707](https://community.dremio.com/u/firefly707)\
**Post date:** [September 21, 2018, 9:06pm UTC](https://community.dremio.com/t/is-there-a-robust-dremio-sql-reference-available/1893/2 "2018-09-21T21:06:31Z")

</div>

Would this be helpful? [https://docs.dremio.com/sql-reference/](https://docs.dremio.com/sql-reference/)

BTW - We don’t support DECLARE in Dremio SQL. We’re happy to help with any window function questions, just let us know.