Previous Topic: SQL Server Property EditorsNext Topic: New r8 SQL Server 2008 Support in erwin Data Modeler


SQL Server Support Summary

The following table summarizes support for all SQL Server property editors, and shows which editors are available to you by SQL Server version.

Note: Support is not provided for any password or encryption key information in the model.

Object Type

SQL Server 2008

Aggregate

Yes

Application Role

Yes

Assembly

Yes

Asymmetric Key

Yes

Certificate

Yes

Credential

Yes

Cryptographic Provider

Yes

Database

Yes

Database Audit Specification

Yes

Database Encryption Key

Yes

Database Role

Yes

Database Triggers

Yes

File

Yes

Filegroup (Database)

Yes

FullText Catalog

Yes

FullText Index

Yes

FullText Stoplist

Yes

Function

Yes

Login

Yes

Partition Function

Yes

Partition Scheme

Yes

Physical File

Yes

Permission

Yes

Schema

Yes

Script Template

Yes

Server Audit

Yes

Server Audit Specification

Yes

Server Triggers

Yes

Spatial Index

Yes

Stored Procedure

Yes

Symmetric Key

Yes

Synonym

Yes

Table

Yes

Table Index

Yes

Table Triggers

Yes

User Ids

Yes

View

Yes

View Index

Yes

View Triggers

Yes

Workload Group

Yes

XML Index

Yes

XML Schema Collection

Yes

More information:

SQL Server Property Editors

SQL Server 2008 Property Editors