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

SQL Server 2005 Property Editors

The following list summarizes support for SQL Server 2005 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 2005 property values.

• Aggregate
• Application Role
• Assembly
• Asymmetric Key
• Certificate
• Credential
• Database
• Database Role
• File
• File Group (Database)
• Full-Text Catalog
• Full-Text Index
• Function
• Login
• Partition Function
• Partition Scheme
• Permission
• Schema
• Symmetric Key
• Synonym
• User Ids
• XML Index
• XML Schema Collection

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

Define a Table Index in SQL Server 2005

Define SQL Server 2005 Views

Define a View Index in SQL Server 2005

Define SQL Server Database Triggers

Define SQL Server 2005 Triggers

Define SQL Server Table Triggers

Define SQL Server View Triggers

Define SQL Server Stored Procedures

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