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

SQL Server 2008 Property Editors

The following list summarizes support for SQL Server 2008 physical property editors. These editors provide additional support beyond the basic CA ERwin Data Modeler physical objects such as tables, indexes, scripts, and stored procedures, and are used to define more specific SQL Server 2008 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
• Server Audit
• Server Audit Specification
• Spatial Index
• Symmetric Key
• Synonym
• User Ids
• Workload Group
• XML Index
• XML Schema Collection

Note: For more information about specific SQL Server 2008 property values, see your SQL Server 2008 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.

More information:

Define a Table in SQL Server 2008

Define a Table Index in SQL Server 2008

Define a View in SQL Server 2008

Define a View Index in SQL Server 2008

SQL Server Browser for Functions, Script Templates, and Stored Procedures

Define SQL Server Database Triggers

Define SQL Server 2008 Triggers

Define SQL Server Table Triggers

Define SQL Server View Triggers