Features Within the Application Model (Partially Contained Database)

[This documentation is for preview only, and is subject to change in later releases. Blank topics are included as placeholders.]

Any entity within the application model that uses the features listed in the tables below is considered to be contained. The features listed below reside within the application model, therefore the use of them by entities within the application model does not cross the application boundary.

See Features Outside of the Application Model (Partially Contained Database) for a list of features that cannot be used by an entity within the application model.

Unless otherwise noted, the following features can be used in the same way as used in a non-contained database.

sys.allocation_units

sys.plan_guides

sys.assemblies

sys.procedures

sys.assembly_files

sys.referential_constraints

sys.assembly_modules

sys.registered_search_properties

sys.assembly_references

sys.registered_search_property_lists

sys.assembly_types

sys.remote_service_bindings

sys.certificates

sys.routes 

sys.change_tracking_tables

sys.routine_columns

sys.charsets

sys.routines

sys.check_constraints

sys.schemas

sys.column_domain_usage

sys.schemata

sys.column_privileges

sys.server_assembly_modules

sys.column_type_usages

sys.server_contract_message_usages

sys.column_xml_schema_collection_usages

sys.server_contract_usages

sys.columns

sys.server_contracts

sys.computed_columns

sys.server_message_types

sys.constraint_column_usage

sys.server_queue_usages

sys.constraint_table_usage

sys.server_queues

sys.conversation_endpoints

sys.services

sys.conversation_groups 

sys.spatial_index_tessellations

sys.conversation_priorities

sys.spatial_indexes

sys.crypt_properties

sys.spatial_reference_systems

sys.data_audit_specification

(Audit is not available in contained databases.)

sys.sql_dependencies

sys.data_audit_specificationi_details

(Audit is not available in contained databases.)

sys.sql_expression_dependencies

sys.data_spaces

sys.sql_modules

sys.database_permissions

sys.stats

sys.database_principals

sys.stats_columns

sys.database_principals_aliases

sys.symmetric_keys

sys.database_role_members

sys.synonyms

sys.default_constraints

sys.syscolumns

sys.event_notification_event_types

sys.syscomments

sys.event_notifications

sys.sysconstraints

sys.events

sys.sysdepends

sys.extended_properties

sys.sysfilegroups

sys.filegroups

sys.sysforeignkeys

sys.foreign_key_columns

sys.sysindexes

sys.foreign_keys

sys.sysindexkeys

sys.fulltext_catalogs

sys.syslanguages

sys.fulltext_document_types

sys.sysmembers

sys.fulltext_index_catalog_usages

sys.sysobjects

sys.fulltext_index_columns

sys.sysprotects

sys.fulltext_index_fragments

sys.sysrefernences

sys.fulltext_indexes

sys.systable_constraints

sys.fulltext_languages

sys.systypes

sys.fulltext_stoplists

sys.sysusers

sys.fulltext_stopwords

sys.table_privileges

sys.fulltext_system_stopwords

sys.table_types

sys.function_order_columns

sys.tables

sys.identity_columns

sys.transmission_queue

sys.index_columns

sys.trigger_events

sys.indexes

sys.triggers

sys.internal_tables

sys.type_assembly_usages

sys.key_column_usage

sys.types

sys.key_constraints

sys.user_token

sys.key_encryptions

sys.view_column_usage

sys.message_type_xml_schema_collection_usages

sys.view_table_usage

sys.messages

sys.views

sys.module_assembly_usages

sys.xml_indexes

sys.numbered_procedure_parameters

sys.xml_schema_attributes

sys.numbered_procedures

sys.xml_schema_collections

sys.openkeys

sys.xml_schema_component_placements

sys.parameter_type_usages

sys.xml_schema_components

sys.parameter_xml_schema_collection_usages

sys.xml_schema_elements

sys.parameters

sys.xml_schema_facets

sys.partition_functions

sys.xml_schema_model_groups

sys.partition_parameters

sys.xml_schema_namespaces

sys.partition_range_values

sys.xml_schema_types

sys.partition_schemes

sys.xml_schema_wildcard_namespaces

sys.partitions

sys.xml_schema_wildcards

All data types, excluding user-defined CLR data types, can be used with features within the application model.

-- (Comment)

FOR XML

- (Negative)

FREETEXT

/*…*/ (Comment)

FREETEXTTABLE

[] (Wildcard - Characters to match)

FROM

[^] (Wildcard - Characters to not match)

GET CONVERSTATION GROUP

\ (Backslash)

GO

+ (Unary Plus)

GOTO

ADD SIGNATURE

GROUP BY

ALL

GROUPING_ID

ALL

HAVING

AND

Heaps  in temp tables? (select into)

AND

IDENTITY (Property)

ANY

IF…ELSE

ANY

IN

APPLOCK_MODE

INSERT

APPLOCK_MODE

insert (XML DML)

APPLOCK_TEST

IS [NOT] NULL

BEGIN CONVERSATION TIMER

Join Hints

BEGIN CONVERSATION TIMER

KILL

BEGIN DIALOG CONVERSATION

KILLQUERY NOTIFICATION SUBSCRIPTION

BEGIN TRANSACTION

LIKE

BEGIN…END

Local temp tables

BETWEEN

MERGE

BETWEEN

MIN_ACTIVE_ROWVERSION

BINARY_CHECKSUM

modify() Method (xml Data Type)

BINARY_CHECKSUM

MOVE CONVERSATION

BREAK

nodes() Method (xml Data Type)

BREAK

NOT / Not Equal To

CATCH (TRY…CATCH)

ODBC Scalar Functions

CHANGETABLE

OPEN

CHANGETABLE

OPEN ASYMMETRIC KEY

CHECKPOINT

OPEN SYMMETRIC KEY

CHECKSUM

OPTION Clause

CHECKSUM - AGGREGATE

OR

CLOSE

ORDER BY Clause

CLOSE

OUTPUT Clause

CLOSE ALL ASYMMETRIC KEYS

OVER Clause

CLOSE ALL MASTER KEYS

PREPARE TRANSACTION

CLOSE ALL SYMMETRIC KEY

PRINT

CLOSE ASYMMETRIC KEY

Query Hints

CLOSE CURSOR

query() Method (xml Data Type)

CLOSE MASTER KEY

RAISERROR

CLOSE SYMMETRIC KEY

READTEXT

COLLATE

RECEIVE

COMMIT TRANSACTION

REFERENCES

COMMIT WORK

replace value of (XML DML)

COMMIT WORK

Reserved Keywords

COMPUTE

RETURN

COMPUTE

returnstatus

Constants

REVERT

Constants

ROLLBACK TRANSACTION

CONTAINS

ROLLBACK WORK

CONTAINS

SAVE TRANSACTION

CONTAINSTABLE

SAVEPOINT

CONTAINSTABLE

SELECT

CONTEXT_INFO

SELECT @ local variable

CONTEXT_INFO

SELECT INTO Clause

CONTINUE

SEND

CONTINUE

SOME | ANY

CONVERT

sys.user_token

CRYPT GEN RANDOM

table

CURSORDELETE

Table Hints

Cursors

TERTIARY_WEIGHTS

CURSORUPDATE

TOP

DEALLOCATE

TRACE QUEUE TASK

DEALLOCATE CURSOR

Transactions

DECLARE @ local variable

TRIGGER_NESTLEVEL

DECLARE @local_variable

TRUNCATE TABLE

DECLARE @table

TRY…CATCH

DECLARE CURSOR

UNION

DELETE

UPDATE

DELETE

UPDATE STATISTICS

delete (XML DML)

UPDATETEXT

DENY

USER

ENABLE TRIGGER

value() Method (xml Data Type)

END (BEGIN…END)

WAITFOR

END CONVERSATION

WHERE

EXCEPT and INTERSECT

WHILE

EXECUTE

WITH CHANGE_TRACKING_CONTEXT

exist() Method (xml Data Type)

WITH common_table_expression

EXISTS

WITH XMLNAMESPACES

FETCH

WRITETEXT

fn_helpcollations

XQuery

CREATE/DROP/ALTER Statements

ALTER AUTHORIZATION

CREATE/DROP/ALTER FULLTEXT STOPLIST

ALTER/DROP REMOTE SERVICE BINDING

CREATE/DROP/ALTER INDEX

CREATE SPATIAL INDEX

CREATE/DROP/ALTER MESSAGE TYPE

CREATE XML INDEX

CREATE/DROP/ALTER PARTITION FUNCTION

CREATE XML SCHEMA COLLECTION

CREATE/DROP/ALTER PARTITION SCHEME

CREATE/DROP APPLICATION ROLE

CREATE/DROP/ALTER QUEUE

CREATE/DROP CONTRACT

CREATE/DROP/ALTER SEARCH PROPERTY LIST

CREATE/DROP DEFAULT

CREATE/DROP/ALTER SERVICE

CREATE/DROP ROLE

DROP AGGREGATE

CREATE/DROP RULE

DROP ASSEMBLY

CREATE/DROP SCHEMA

DROP CERTIFICATE

CREATE/DROP STATISTICS

DROP DATABASE AUDIT SPECIFICATION

CREATE/DROP SYNONYM

DROP EVENT NOTIFICATION

CREATE/DROP TYPE

DROP ROUTE

CREATE/DROP VIEW

DROP TABLE

CREATE/DROP/ FUNCTION

DROP USER

CREATE/DROP/ PROCEDURE

DROP/ALTER FULLTEXT INDEX

CREATE/DROP/ALTER ASYMMETRIC KEY

DROP/ALTER SYMMETRIC  KEY

CREATE/DROP/ALTER BROKER PRIORITY

DROP/ALTER XMLSCHEMA

CREATE/DROP/ALTER FULLTEXT CATALOG

GRANT/DENY/REVOKE Statements

GRANT/DENY/REVOKE Assembly Permissions

GRANT/DENY/REVOKE Database Permissions

GRANT/DENY/REVOKE Database Principal Permissions

GRANT/DENY/REVOKE Full-text Catalog Permissions

GRANT/DENY/REVOKE Object Permissions

GRANT/DENY/REVOKE Schema Permissions

GRANT/DENY/REVOKE Type Permissions

GRANT/DENY/REVOKE XML Schema Collection Permissions

GRANT/REVOKE/DENY Application Role

GRANT/REVOKE/DENY Asymmetric Key Permissions

GRANT/REVOKE/DENY Certificate Permissions

GRANT/REVOKE/DENY Contract

GRANT/REVOKE/DENY Fulltext Stoplist

GRANT/REVOKE/DENY Message Type

GRANT/REVOKE/DENY Remote Service Binding

GRANT/REVOKE/DENY Role

GRANT/REVOKE/DENY Route

GRANT/REVOKE/DENY Search Property List

GRANT/REVOKE/DENY Service Broker Permissions

GRANT/REVOKE/DENY Symmetric Key Permissions

GRANT/REVOKE/DENY User

SET Statements

SET @ local variable

SET LANGUAGE

SET ANSI_DEFAULTS

SET LOCK_TIMEOUT

SET ANSI_NULL_DFLT_OFF

SET NOCOUNT

SET ANSI_NULL_DFLTS_ON

SET NOEXEC

SET ANSI_NULLS

SET NUMERIC_ROUNDABORT

SET ANSI_PADDING

SET OFFSETS

SET ANSI_WARNINGS

SET PARSEONLY

SET ARITHABORT

SET QUOTED_IDENTIFIER

SET ARITHIGNORE

SET ROWCOUNT

SET CONCAT_NULL_YIELDS_NULL

SET SHOWPLAN_ALL

SET CONTEXT_INFO

SET SHOWPLAN_TEXT

SET CURSOR_CLOSE_ON_COMMIT

SET SHOWPLAN_XML

SET DATEFIRST

SET STATISTICS IO

SET DATEFORMAT

SET STATISTICS PROFILE

SET DEADLOCK_PRIORITY

SET STATISTICS TIME

SET DISABLE_DEF_CNST_CHK

SET STATISTICS XML

SET FIPS_FLAGGER

SET TEXTSIZE

SET FMTONLY

SET TRANSACTION ISOLATION LEVEL

SET FORCEPLAN

SET XACT_ABORT

SET IDENTITY_INSERT

SETUSER

SET IMPLICIT_TRANSACTIONs

@@CURSOR_ROWS

GETDATE

@@DATEFIRST

GETUTCDATE

@@DBTS

GROUPING

@@DEFAULT_LANGID

HAS_PERMS_BY_NAME 

@@ERROR

HASHBYTES

@@FETCH_STATUS

IDENT_CURRENT

@@IDENTITY

IDENT_INCR

@@LANGID

IDENT_SEED

@@LANGUAGE

IDENTITYPROPERTY

@@LOCK_TIMEOUT

INDEX_COL

@@MAX_PRECISION

INDEXKEY_PROPERTY

@@MICROSOFTVERSION

INDEXPROPERTY

@@NESTLEVEL

IS_MEMBER

@@OPTIONS

IS_OBJECTSIGNED

@@PROCID

ISDATE

@@ROWCOUNT

ISNULL

@@ROWCOUNTBIG

ISNUMERIC

@@SPID

KEY_GUID

@@TEXTSIZE

KEY_ID

@@TIMETICKS

KEY_NAME

@@TRANCOUNT

LEFT

@@VERSION

LEN

ABS

LOG

ACOS

LOG10

APP_NAME

LOWER

APPLOCK_MODE

LTRIM

APPLOCK_TEST

MAX

ASCII

MIN

ASIN

MIN_ACTIVE_ROWVERSION

ASSEMBLYPROPERTY

MONTH

ASYMKEY_ID

NCHAR

ASYMKEYPROPERTY

NEWID

ATAN

NTILE

ATN2

NULLIF

AVG

OBJECT_DEFINITION

BCPCOLLATIONNAME

OBJECT_ID

BINARY_CHECKSUM

OBJECT_NAME

CASE

OBJECT_SCHEMA_NAME

CAST and CONVERT

OBJECTPROPERTY

CEILING

OBJECTPROPERTYEX

CERT_ID

ODBCPREC

certencoded

ODBCSCALE

certprivatekey

ORIGINAL_DB_NAME

CERTPROPERTY

PARSENAME

CHANGE_TRACKING_CURRENT_VERSION

PATINDEX

CHANGE_TRACKING_IS_COLUMN_IN_MASK

PERMISSIONS

CHANGE_TRACKING_MIN_VALID_VERSION

PI

CHAR

POWER

CHARINDEX

PROGRAM_NAME

CHECKSUM

PWDCOMPARE

CHECKSUM_AGG

PWDENCRYPT

COALESCE

QUOTENAME

COL_LENGTH

RADIANS

COL_NAME

RAND

COLLATIONNAME

RANK

COLLATIONPROPERTYCollationpropertyfromid

REPLACE

COLUMNPROPERTY

REPLICATE

COLUMNS_UPDATED

REVERSE

CompressNumeric

RIGHT

CONTEXT_INFO

ROUND

COS

ROW_NUMBER

COT

ROWCOUNT_BIG

COUNT

RTRIM

COUNT_BIG

SCHEMA_ID

CRYPT_GEN_RANDOM

SCHEMA_NAME

CURRENT_REQUEST_ID

SCOPE_IDENTITY

CURRENT_TIMESTAMP

SESSION_USER

CURRENT_USER

SESSIONPROPERTY

CURSOR_STATUS

SIGN

DATABASE_PRINCIPAL_ID

SIGNBYASYMKEY

DATABASEPROPERTYEX

SIGNBYCERT

DATALENGTH

SIN

DATEADD

SOUNDEX

DATEDIFF

SPACE

DATENAME

SQL_VARIANT_PROPERTY

DATEPART

SQRT

DAY

SQUARE

DB_ID

STATS_DATE

DB_NAME

STDEV

DECRYPTBYASYMKEY

STDEVP

DECRYPTBYCERT

STR

DECRYPTBYKEY

STUFF

DECRYPTBYKEYAUTOASYMKEY

SUBSTRING

DECRYPTBYKEYAUTOCERT

SUM

DECRYPTBYPASSPHRASE

SWITCHOFFSET

DEGREES

SYMKEYPROPERTY

DENSE_RANK

SYSDATETIME

DIFFERENCE

SYSDATETIMEOFFSET

ENCRYPTBYASYMKEY

SYSTEM_USER

ENCRYPTBYCERT

SYSUTCDATETIME

ENCRYPTBYKEY

TAN

ENCRYPTBYPASSPHRASE

TERTIARY_WEIGHTS

ERROR_LINE

TEXTPTR

ERROR_MESSAGE

TEXTVALID

ERROR_NUMBER

TODATETIMEOFFSET

ERROR_PROCEDURE

TRIGGER_NESTLEVEL

ERROR_SEVERITY

TYPE_ID

ERROR_STATE

TYPE_NAME

EVENTDATA

TYPEPROPERTY

EXP

UNCOMPRESS

FILEGROUP_ID

UNICODE

FILEGROUP_NAME

UPDATE()

FILEGROUPROPERTY

UPPER

FLOOR

USER_ID

FORMATMESSAGE

USER_NAME

FULLTEXTCATALOGPROPERTY

VAR

FULLTEXTSERVICEPROPERTY

VARP

GET_FILESTREAM_TRANSACTION_CONTEXT

VERIFYSIGNEDBYASYMKEY

GET_FILESTREAM_TRANSACTION_CONTEXT

VERIFYSIGNEDBYCERT

GETANSINULL

XACT_STATE

XML_SCHEMA_NAMESPACE

YEAR

sys.fn_builtin_permissions

sys.fn_my_permissions

sys.fn_check_object_signatures

sys.fn_validate_plan_guide

sys.fn_helpcollations

ORMask

sys.fn_listextendedproperty

sp_addapprole

sp_help_fulltext_tables

sp_addextendedproperty

sp_help_fulltext_tables_cursor

sp_addrole

sp_help_spatial_geography_index

sp_addrolemember

sp_help_spatial_geography_index_xml

sp_addtype

sp_help_spatial_geometry_index

sp_approlepassword

sp_help_spatial_geometry_index_xml

sp_autostats

sp_helpconstratint

sp_batch_params

sp_helpfilegroup

sp_bindefault

sp_helpfixedrole

sp_bindrule

sp_helpindex

sp_change_tracking_waitforchanges

sp_helplanguage

sp_changeobjectowner

sp_helpntgroup

sp_column_privileges

sp_helprole

sp_columns

sp_helprolemember

sp_control_plan_guide

sp_helprotect

sp_create_plan_guide

sp_helpstats

sp_create_plan_guide_from_handle

sp_helptext

sp_createstats

sp_helptrigger

sp_curstor_list

sp_helpuser

sp_datatype_info

sp_indexoption

sp_dbcmptlevel

sp_invalidate_textpr

sp_dbfixedrolepermission

sp_pkeys

sp_depends

sp_prepare

Containment depends upon the statement executed.

sp_describe_cursor

sp_prepexec

sp_describe_cursor_columns

sp_prepexecrpc

sp_describe_cursor_tables

sp_recompile

sp_dropapprole

sp_refreshsqlmodule

sp_dropextendedproperty

sp_refreshview

sp_droprole

sp_releaseapplock

sp_droprolemember

sp_rename

sp_droptype

sp_server_info

sp_dropuser

sp_setapprole

sp_exectute

sp_settriggerorder

sp_executesql 

Containment depends upon the statement executed.

sp_spaceused

sp_fkeys

sp_special_columns

sp_fulltext_catalog

sp_sproc_columns

sp_fulltext_column

sp_statistics

sp_fulltext_database

sp_stored_procedures

sp_fulltext_keymappings

sp_table_privileges

sp_fulltext_pendingchanges

sp_tableoptions

sp_fulltext_table

sp_tables

sp_get_query_template

sp_unbindefault

sp_getapplock

sp_unbindrule

sp_help

sp_unsetapprole

sp_help_fulltext_catalog_components

sp_updateextendedproperty

sp_help_fulltext_catalogs

sp_updatestats

sp_help_fulltext_catalogs_cursor

sp_validname

sp_help_fulltext_columns

sp_xml_preparedocument

sp_help_fulltext_columns_cursor

sp_xml_removedocument

sp_help_fulltext_system_components

CHECKALLOC

CHECKTABLE

CHECKCATALOG

CLEANTABLE

CHECKCONSTRAINTS

HELP

CHECKDB

SHOW_STATISTICS

CHECKFILEGROUP

SHRINKDATABASE

CHECKIDENT

USEROPTIONS

Show: