Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Azure Property Editors › SQL Azure Database Support in erwin® Data Modeler › Table and Column Properties

Table and Column Properties

The following describes new or changed properties in the property editor and related information.

• SQL Azure does not support the following arguments and options when using the CREATE TABLE statement:
  • ON keyword { partition_schema_name | filegroup | "default" }
  • TEXTIMAGE_ON
  • FILESTREAM_ON
  • <column_definition>
    • FILESTREAM
    • NOT FOR REPLICATION
    • ROWGUIDCOL
    • SPARSE
  • <data type>
    • CONTENT
    • DOCUMENT
    • xml_schema_collection
  • <column_constraint>
    • FILLFACTOR
    • ON
    • NOT FOR REPLICATION
  • <computed_column_definition>
    • FILLFACTOR
    • NOT FOR REPLICATION
    • ON
  • <column_set_definition>
  • <table_constraint>
    • FILLFACTOR
    • ON
    • NOT FOR REPLICATION
  • <table_option>
  • <index_option>
    • PAD_INDEX
    • FILLFACTOR
    • ALLOW_ROW_LOCKS
    • ALLOW_PAGE_LOCKS
    • DATA_COMPRESSION
    • ON PARTITIONS

The following describes the impacts on the SQL Azure Table Editor as compared to the SQL Server 2008 Table Editor:

• On the General tab, the Storage Locations, Change Tracking Options, and Table Options sections are unavailable.
• The Partitions, ChangeDataCapture, and Data Compression tabs were removed.
• On the Validation tab, the Is Not for Replication property is unavailable. The Disabled property has been set to True.

For table column properties, the impacts on the SQL Azure Table Column Editor as compared to the SQL Server 2008 Table Column Editor include:

• On the SQL Server tab, the Options section is unavailable.
• On the Constraint tab, the Is Not for Replication property is unavailable. The Disabled property has been set to True.