Export (0) Print
Expand All

Partially Supported Transact-SQL Statements (Azure SQL Database)

Updated: February 21, 2014

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 2014. The following table is a list of such Transact-SQL statements.

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

 

ALTER AUTHORIZATION

CREATE PROCEDURE

DROP TRIGGER

ALTER DATABASE

CREATE SPATIAL INDEX

DISABLE TRIGGER

ALTER FUNCTION

CREATE SYNONYM

ENABLE TRIGGER

ALTER INDEX

CREATE TABLE

EXECUTE

ALTER LOGIN

CREATE TRIGGER

EXECUTE AS

ALTER PROCEDURE

CREATE TYPE

EXECUTE AS Clause

ALTER TABLE

CREATE USER

GRANT Database Permissions

ALTER TRIGGER

CREATE VIEW

GRANT Database Principal Permissions

ALTER USER

DENY Database Permissions

GRANT Type Permissions

ALTER VIEW

DENY Database Principal Permissions

INSERT

CREATE DATABASE

DENY Type Permissions

KILL

CREATE FUNCTION

DROP DATABASE

REVOKE Database Permissions

CREATE INDEX

DROP INDEX

REVOKE Database Principal Permissions

CREATE LOGIN

DROP TABLE

REVOKE Type Permissions

USE

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

See Also

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2014 Microsoft