Object Definitions

What are object definitions

While you are editing your SQL Queries, you’re commonly required to reference object definitions within your database model. For example, say you are writing a query using a certain table column and need to know if it could contain NULL values. In this case, the standard IntelliSense capability of suggesting column names falls a bit short. Instead, what is needed is the full definition of the table object.

Since your database could contain hundreds of tables, each of which could store numerous columns, it is often a pain to quickly retrieve table and column definitions by browsing for these object definitions in the sidebar. To remedy this, ADS provides direct access to object definitions without leaving the editor window. Simply right click on any table name in your query, and a couple of options will pop up. The figure below captures this pop up when drilling into the table named product: