Object Type

SQL Server 2008

SQL Server 2012

SQL Server 2014

SQL Server 2016

Aggregates

Yes

Yes

Yes

Yes

Always Encrypted Keys

No

No

No

Yes

Application Roles

Yes

Yes

Yes

Yes

Assemblies

Yes

Yes

Yes

Yes

Asymmetric Keys

Yes

Yes

Yes

Yes

Certificates

Yes

Yes

Yes

Yes

Credentials

Yes

Yes

Yes

Yes

Cryptographic Providers

Yes

Yes

Yes

Yes

Database Audit Specification

Yes

Yes

Yes

Yes

Database Encryption Keys

Yes

Yes

Yes

Yes

Database Roles

Yes

Yes

Yes

Yes

Databases

Yes

Yes

Yes

Yes

Database Triggers

Yes

Yes

Yes

Yes

Files

Yes

Yes

Yes

Yes

File Groups (Databases)

Yes

Yes

Yes

Yes

Full-Text Catalogs

Yes

Yes

Yes

Yes

Full-Text Indexes (Table)

Yes

Yes

Yes

Yes

Full-Text Stoplists

Yes

Yes

Yes

Yes

Functions

Yes

Yes

Yes

Yes

Logins

Yes

Yes

Yes

Yes

Partition Functions

Yes

Yes

Yes

Yes

Partition Schemes

Yes

Yes

Yes

Yes

Physical Files (Databases)

Yes

Yes

Yes

Yes

Permissions

Yes

Yes

Yes

Yes

Resource Pools

Yes

Yes

Yes

Yes

Schemas

Yes

Yes

Yes

Yes

Sequences

No

Yes

Yes

Yes

Server Audits

Yes

Yes

Yes

Yes

Server Audit Specification

Yes

Yes

Yes

Yes

Server Triggers

Yes

Yes

Yes

Yes

Stored Procedures

Yes

Yes

Yes

Yes

Symmetric Keys

Yes

Yes

Yes

Yes

Spatial Indexes (Table)

Yes

Yes

Yes

Yes

Synonyms

Yes

Yes

Yes

Yes

Tables

Yes

Yes

Yes

Yes

ColumnStore Indexes (Table)

No

Yes

Yes

Yes

XML Indexes (Table)

Yes

Yes

Yes

Yes

Indexes (Table)

Yes

Yes

Yes

Yes

Table Triggers

Yes

Yes

Yes

Yes

Triggers

Yes

Yes

Yes

Yes

User Ids

Yes

Yes

Yes

Yes

Views

Yes

Yes

Yes

Yes

View Indexes

Yes

Yes

Yes

Yes

View Triggers

Yes

Yes

Yes

Yes

Workload Groups

Yes

Yes

Yes

Yes

XML Schema Collections

Yes

Yes

Yes

Yes