Azure SQL Database Reference Documentation

API References

Explore the comprehensive API references for Azure SQL Database. These documents provide detailed information on REST APIs, SDKs, and command-line interfaces.

REST API Reference

Resource Description Link
Databases Manage SQL databases, including creation, deletion, and configuration. View
Elastic Pools Manage elastic pools for efficient resource sharing. View
Servers Manage SQL server instances. View
Firewall Rules Configure network access rules. View
Operations Monitor the status of asynchronous operations. View

SDK Reference

Links to SDK documentation for various programming languages.

T-SQL Reference

While Azure SQL Database is highly compatible with SQL Server, some T-SQL elements might differ. This section provides a reference for T-SQL syntax and functions specific to or commonly used with Azure SQL Database.

Commonly Used T-SQL Commands

  • CREATE DATABASE
  • ALTER DATABASE
  • CREATE TABLE
  • ALTER TABLE
  • SELECT, INSERT, UPDATE, DELETE

System Catalog Views

Explore system catalog views for querying database metadata:

  • sys.databases
  • sys.tables
  • sys.columns
  • sys.dm_exec_sessions

For a complete and authoritative T-SQL reference, please consult the official Microsoft SQL Server documentation, as Azure SQL Database aims for high compatibility.

Microsoft SQL Server T-SQL Reference

Azure CLI Commands

Reference for Azure CLI commands used to manage Azure SQL Database resources.

Command Group Description Example Link
az sql db Commands to manage SQL databases. az sql db create --resource-group MyResourceGroup --server MyServer --name MyDatabase --edition Basic View
az sql server Commands to manage SQL servers. az sql server create --resource-group MyResourceGroup --name MyServer --location westus View
az sql elastic-pool Commands to manage elastic pools. az sql elastic-pool create --resource-group MyResourceGroup --server MyServer --name MyPool --edition Standard --capacity 200 View