Available Data Providers are:
- Connection via ADO
- Native Connection
Connection via ADO:
Native Connection:
Reverse Engineering Settings
- Check Graph Table Columnsto include graph table columns $node_id", "$edge_id", "$from_id", "$to_id in your RE
External Table support (PolyBase external table that references data stored in Hadoop cluster or Azure blob storage). External Tables can be found in Physical Model Explorer.
Security Policy support (for row-level security). Security Policies can be found in Physical Model Explorer.
New model objects with simplified support:
- Column Encryption Key - currently without any properties, used for Encrypting Columns.
- External Data Source - currently without any properties, used for External Table.
- External File Format - currently without any properties, used for External Table.
IF EXISTS support for DROP commands of certain object types:
-
Entity, View, Relation, Trigger (entity/view), Key, Index, Default, Rule, DictType, UDT, Procedure, Function, Aggregate (Functions), Synonym, Assembly, Sequence, FileTable
- To use the clause, enable the Check Object Existence Before Processing Drop Commands option in DDL Script Generation | Detail Settings.
![](/ja-jp/technical-documents/image/3bbd83c1-2907-44c1-8cae-6d8b58fb9548)
Entity
Attribute
- Dynamic Data Masking support for Attributes (Attribute Properties | Masking and Encryption tab | Dynamic Data Masking)
- Always Encrypted support for Attributes (Attribute Properties | Masking and Encryption tab | Encrypting Columns)
Function
- New Function types:
- Natively Compiled Scalar Function
- Natively Compiled Inline Table-valued Function
- EXECUTE AS CALLER for Natively Compiled Stored Procedure Functions (used by default).
Index
- New parameter - COMPRESSION DELAY for COLUMNSTORE Indexes.
- Filter predicates (WHERE) can be now used in non-clustered COLUMNSTORE Indexes.
- Non-clustered Indexes can be now created even when CLUSTERED COLUMNSTORE Indexes already exist.
User
Misc.
- Support for Stretch Database (REMOTE_DATA_ARCHIVE) in SQL Server 2016
- To create a Table for remote data archive see Entity Properties | Stretch Database Properties
|
NOTE: REMOTE_DATA_ARCHIVE is not supported for Memory Optimized Tables. |
Available Data Providers are:
- Connection via ADO
- Native Connection
Connection via ADO:
Native Connection:
Reverse Engineering Settings
- Check Graph Table Columnsto include graph table columns $node_id", "$edge_id", "$from_id", "$to_id in your RE