Export (0) Print
Expand All

Partially Supported Transact-SQL Statements (Azure SQL Database)

Updated: February 21, 2014

This topic is OBSOLETE. You can find the most current version in the SQL 14 Transact-SQL Reference.

In Microsoft Microsoft Azure SQL Database, some Transact-SQL statements do not support some of the arguments and options that exist in their corresponding Transact-SQL statements in SQL Server 2008. The following table provides a list of such Transact-SQL statements.    

 

ALTER AUTHORIZATION (Azure SQL Database)

CREATE PROCEDURE (Azure SQL Database)

DROP TRIGGER (Azure SQL Database)

ALTER DATABASE (Azure SQL Database)

CREATE SPATIAL INDEX (Azure SQL Database)

DISABLE TRIGGER (Azure SQL Database)

ALTER FUNCTION (Azure SQL Database)

CREATE SYNONYM (Azure SQL Database)

ENABLE TRIGGER (Azure SQL Database)

ALTER INDEX (Azure SQL Database)

CREATE TABLE (Azure SQL Database)

EXECUTE (Azure SQL Database)

ALTER LOGIN (Azure SQL Database)

CREATE TRIGGER (Azure SQL Database)

EXECUTE AS (Azure SQL Database)

ALTER PROCEDURE (Azure SQL Database)

CREATE TYPE (Azure SQL Database)

EXECUTE AS Clause (Azure SQL Database)

ALTER TABLE (Azure SQL Database)

CREATE USER (Azure SQL Database)

GRANT Database Permissions (Azure SQL Database)

ALTER TRIGGER (Azure SQL Database)

CREATE VIEW (Azure SQL Database)

GRANT Database Principal Permissions (Azure SQL Database)

ALTER USER (Azure SQL Database)

DENY Database Permissions (Azure SQL Database)

GRANT Type Permissions (Azure SQL Database)

ALTER VIEW (Azure SQL Database)

DENY Database Principal Permissions (Azure SQL Database)

INSERT (Azure SQL Database)

CREATE DATABASE (Azure SQL Database)

DENY Type Permissions (Azure SQL Database)

KILL (Azure SQL Database)

CREATE FUNCTION (Azure SQL Database)

DROP DATABASE (Azure SQL Database)

REVOKE Database Permissions (Azure SQL Database)

CREATE INDEX (Azure SQL Database)

DROP INDEX (Azure SQL Database)

REVOKE Database Principal Permissions (Azure SQL Database)

CREATE LOGIN (Azure SQL Database)

DROP TABLE (Azure SQL Database)

REVOKE Type Permissions (Azure SQL Database)

USE (Azure SQL Database) Note- In Microsoft Microsoft Azure SQL Database the USE statement does not switch between databases. To change databases, you must directly connect to the database.

ImportantImportant
For more information about Transact-SQL grammar, usage, and examples, see Transact-SQL Reference (Database Engine) in SQL Server Books Online.

See Also

Community Additions

Show:
© 2014 Microsoft