Databases Reference
In-Depth Information
Table B-2.
Partially Supported T-SQL Statements
ALTER AUTHORIZATION
CREATE SPATIAL INDEX
DROP TRIGGER
ALTER DATABASE
CREATE SYNONYM
DISABLE TRIGGER
ALTER FUNCTION
CREATE TABLE
ENABLE TRIGGER
ALTER INDEX
CREATE TRIGGER
EXECUTE
ALTER LOGIN
CREATE TYPE
EXECUTE AS
ALTER PROCEDURE
CREATE USER
EXECUTE AS
Clause
ALTER TABLE
CREATE VIEW
GRANT
Database Permissions
ALTER TRIGGER
DENY
Database Permissions
GRANT
Database Principal Permission
ALTER USER
DENY
Database Principal Permission
GRANT
Type Permissions
ALTER VIEW
DENY
Type Permissions
INSERT
CREATE DATABASE
DISABLE TRIGGER
REVOKE
Database Permissions
CREATE FUNCTION
DROP DATABASE
REVOKE
Database Principal Permission
CREATE INDEX
DROP INDEX
REVOKE
Type Permissions
CREATE LOGIN
DROP TABLE
USE
CREATE PROCEDURE
For example, when you're creating or altering a stored procedure in Windows Azure SQL Database, the
FOR
REPLICATION
and
ENCRYPTION
options aren't supported. Thus, the following isn't valid:
CREATE PROCEDURE GetUsers
WITH ENCRYPTION
FOR REPLICATION
AS
SET NOCOUNT ON;
SELECT Title, Name, Intro
FROM Users
GO
However, the following is valid:
CREATE PROCEDURE GetUsers
WITH RECOMPILE, EXECUTE AS CALLER
AS
SET NOCOUNT ON;
SELECT Title, Name, Intro
FROM Users
GO
