| title | azdata sql reference |
|---|---|
| titleSuffix | SQL Server big data clusters |
| description | Reference article for azdata sql commands. |
| author | MikeRayMSFT |
| ms.author | mikeray |
| ms.reviewer | mihaelab |
| ms.date | 06/22/2020 |
| ms.topic | reference |
| ms.prod | sql |
| ms.technology | big-data-cluster |
[!INCLUDESQL Server 2019]
The following article provides reference for the sql commands in the azdata tool. For more information about other azdata commands, see azdata reference.
| Command | Description |
|---|---|
| azdata sql shell | The SQL Database CLI allows the user to interact with SQL Server via T-SQL. |
| azdata sql query | The query command allows execution of a T-SQL query. |
The SQL Database CLI allows the user to interact with SQL Server via T-SQL.
azdata sql shell Example command line to start the interactive experience.
azdata sql shellIncrease logging verbosity to show all debug logs.
Show this help message and exit.
Output format. Allowed values: json, jsonc, table, tsv. Default: json.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Increase logging verbosity. Use --debug for full debug logs.
The query command allows execution of a T-SQL query.
azdata sql query --database -d
-qSelect the list of tables names. Database defaults to master.
azdata sql query "SELECT name FROM SYS.TABLES"Database to run query in. Default is master.
T-SQL query to execute.
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Output format. Allowed values: json, jsonc, table, tsv. Default: json.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Increase logging verbosity. Use --debug for full debug logs.
For more information about other azdata commands, see azdata reference. For more information about how to install the azdata tool, see Install azdata to manage SQL Server 2019 big data clusters.