Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Server 2012 Property Editors

SQL Server 2012 Property Editors

The following list summarizes support for SQL Server 2012 physical property editors. These editors provide additional support beyond the basic physical objects such as tables, indexes, scripts, and stored procedures, and are used to define more specific SQL Server 2012 property values.

• Aggregate
• Application Role
• Assembly
• Asymmetric Key
• Certificate
• Credential
• Cryptographic Provider
• Database
• Database Audit Specification
• Database Encryption Key
• Database Role
• File
• File Group (Database)
• Full-Text Catalog
• Full-Text Index
• Full-Text Stoplist
• Function
• Login
• Partition Function
• Partition Scheme
• Permission
• Resource Pool
• Schema
• Sequence
• Server Audit
• Server Audit Specification
• Spatial Index
• Symmetric Key
• Synonym
• Table Columnstore Index
• User Ids
• Workload Group
• XML Index
• XML Schema Collection

Note: For more information about specific SQL Server 2012 property values, see your SQL Server 2012 database documentation. The CA ERwin Data Modeler documentation for the physical property editors provides brief descriptions of the controls in each dialog and tab, which you can use as a point of reference while working with database design features.