Azure SQL Database Reference

Azure SQL Database Reference

Welcome to the Azure SQL Database reference documentation. This section provides detailed information on various aspects of Azure SQL Database, including T-SQL syntax, system views, functions, and administrative tasks.

Transact-SQL (T-SQL) Reference

Explore the rich set of T-SQL features supported by Azure SQL Database. This includes detailed syntax, examples, and explanations for statements, functions, and procedures.

• SELECT Statement
• INSERT Statement
• UPDATE Statement
• DELETE Statement
• CREATE TABLE Statement
• Built-in Functions
• System Catalog Views
• Stored Procedures

Azure SQL Database Management

Learn about the tools and methods for managing your Azure SQL Database instances, including provisioning, scaling, security, and monitoring.

• Resource limits
• Performance tiers
• Security features
• Backup and Restore
• Monitoring and Diagnostics

API and SDK Reference

Access documentation for the Azure SDKs and REST APIs that allow you to programmatically interact with Azure SQL Database.

• Azure SDKs (Python, .NET, Java, Node.js)
• Azure Resource Manager (ARM) Templates
• REST API Reference

Tooling and Development

Information on using tools like SQL Server Management Studio (SSMS), Azure Data Studio, and Visual Studio for developing and managing Azure SQL Databases.

• Connecting with SSMS
• Connecting with Azure Data Studio
• Using Query Store
• Intelligent Query Processing