Azure SQL Database Reference
This section provides comprehensive reference documentation for Azure SQL Database, covering APIs, T-SQL syntax, administration tasks, and configuration options.
SQL Database REST API Reference
Explore the REST APIs for managing your Azure SQL Database resources programmatically.
| Resource Type | Operations | Description |
|---|---|---|
| Servers | List, Create, Update, Delete | Manage SQL Database servers. |
| Databases | List, Create, Update, Delete | Manage databases within SQL servers. |
| Firewall Rules | List, Create, Update, Delete | Configure firewall rules for server access. |
| Elastic Pools | List, Create, Update, Delete | Manage elastic pools for performance scaling. |
Transact-SQL (T-SQL) Reference
Detailed information on T-SQL syntax, functions, and statements specific to Azure SQL Database.
Administration and Configuration
Reference for administrative tasks, security settings, and performance tuning.
- Security Configuration
- Performance Tuning Guide
- Backup and Restore Options
- Monitoring and Diagnostics
Commonly Used Commands
-- Create a new database
CREATE DATABASE MyDatabase;
-- Select a database
USE MyDatabase;
-- Create a table
CREATE TABLE Employees (
EmployeeID INT PRIMARY KEY,
FirstName VARCHAR(50),
LastName VARCHAR(50),
HireDate DATE
);
-- Insert data
INSERT INTO Employees (EmployeeID, FirstName, LastName, HireDate)
VALUES (1, 'John', 'Doe', '2022-01-15');
-- Query data
SELECT * FROM Employees;