azdata sql
Applies to:
Azure Data CLI (azdata
)
The following article provides reference for the sql commands in the azdata tool. For more information about other azdata commands, see azdata reference
Commands
Command | Description |
---|---|
azdata sql shell | The SQL CLI allows the user to interact with SQL Server and Azure SQL via T-SQL. |
azdata sql query | The SQL CLI allows the user to interact with SQL Server and Azure SQL via T-SQL. |
azdata sql shell
The SQL CLI allows the user to interact with SQL Server and Azure SQL via T-SQL.
azdata sql shell [--username -u]
[--database -d]
[--server -s]
[--integrated -e]
[--mssqlclirc]
[--row-limit]
[--less-chatty]
[--auto-vertical-output]
[--encrypt -n]
[--trust-server-certificate -c]
[--connect-timeout -l]
[--application-intent -k]
[--multi-subnet-failover -m]
[--packet-size]
[--dac-connection -a]
[--input-file -i]
[--output-file]
[--enable-sqltoolsservice-logging]
[--prompt]
Examples
Example command line to start the interactive experience.
azdata sql shell
Example command line using a provided server, user, and database
azdata sql shell --server localhost --username sa --database master
Optional Parameters
--username -u
Username to connect to the database.
--database -d
Database name to connect to.
--server -s
SQL Server instance name or address.
--integrated -e
Use integrated authentication on Windows.
--mssqlclirc
Location of mssqlclirc config file.
--row-limit
Set threshold for row limit prompt. Use 0 to disable prompt.
--less-chatty
Skip intro on startup and goodbye on exit.
--auto-vertical-output
Automatically switch to vertical output mode if the result is wider than the terminal width.
--encrypt -n
SQL Server uses SSL encryption for all data if the server has a certificate installed.
--trust-server-certificate -c
The channel will be encrypted while bypassing walking the certificate chain to validate trust.
--connect-timeout -l
Time in seconds to wait for a connection to the server before terminating request.
--application-intent -k
Declares the application workload type when connecting to a database in a SQL Server Availability Group.
--multi-subnet-failover -m
If application is connecting to Always On AG on different subnets, setting this provides faster detection and connection to currently active server.
--packet-size
Size in bytes of the network packets used to communicate with SQL Server.
--dac-connection -a
Connect to SQL Server using the dedicated administrator connection.
--input-file -i
Specifies the file that contains a batch of SQL statements for processing.
--output-file
Specifies the file that receives output from a query.
--enable-sqltoolsservice-logging
Enables diagnostic logging for the SqlToolsService.
--prompt
Prompt format (Default: \d>
Global Arguments
--debug
Increase logging verbosity to show all debug logs.
--help -h
Show this help message and exit.
--output -o
Output format. Allowed values: json, jsonc, table, tsv. Default: json.
--query -q
JMESPath query string. See http://jmespath.org/ for more information and examples.
--verbose
Increase logging verbosity. Use --debug for full debug logs.
azdata sql query
The SQL CLI allows the user to interact with SQL Server and Azure SQL via T-SQL.
azdata sql query -q
[--database -d]
[--username -u]
[--server -s]
[--integrated -e]
Examples
Example command line to select the list of tables names.
azdata sql query --server localhost --username sa --database master -q "SELECT name FROM SYS.TABLES"
Required Parameters
-q
T-SQL query to execute.
Optional Parameters
--database -d
Database name to connect to.
master
--username -u
Username to connect to the database.
--server -s
SQL Server instance name or address.
--integrated -e
Use integrated authentication on Windows.
Global Arguments
--debug
Increase logging verbosity to show all debug logs.
--help -h
Show this help message and exit.
--output -o
Output format. Allowed values: json, jsonc, table, tsv. Default: json.
--query -q
JMESPath query string. See http://jmespath.org/ for more information and examples.
--verbose
Increase logging verbosity. Use --debug for full debug logs.
Next steps
For more information about other azdata commands, see azdata reference.
For more information about how to install the azdata tool, see Install azdata.
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: I hele 2024 udfaser vi GitHub-problemer som feedbackmekanisme for indhold og erstatter det med et nyt feedbacksystem. Du kan få flere oplysninger under:Indsend og få vist feedback om