Typical Storage screen for a SQL Server Table:

Location

Fields

Description

Target Location

The target location that defines the path of the table. Select (local) for a local table or select the target schema if you are locating tables in different schemas.

The Force Target Usage setting in the Tools > Options > Storage > Target Usage removes the local target option from the drop-down list. Refer to Target Usage for details.

When upgrading from a RED version previous to 6.8.2.0 and moving existing objects to a target location, all procedures that reference those objects need to be rebuilt. Any FROM clauses also need to be manually regenerated in order for the table references to be updated to the new [TABLEOWNER] form.

Database Type

The database type for a connection that is used for target DataWarehouse tables.

Database

This field is only visible if using multiple database as target locations for tables in an SQL environment. Refer to Distributing Tables across Multiple SQL Server Databases for details.

Schema

The schema where the table is located.

Create DDL Template

Optional. Specify the template to use when creating a new DDL procedure script. This option is only visible if a DDL template is available for this database type. Default value is None.

Storage

Fields

Description

Filegroup

Select a name from the drop-down list box. If no filegroup name is selected for SQL Server, the default for the database is used.

Compress

This field enables you to compress a particular table/index. Compression options are:

  • NONE
  • PAGE
  • ROW

VarDecimal Storage Format

Enables variable numeric storage in SQL Server for the table. The default is off - no variable numeric storage. To enable variable number storage, the following command must also be run for the SQL Server database: sp_db_vardecimal_storage_format 'DatabaseName', 'ON'

Other

Fields

Description

Optional CREATE Clause

Database-specific-and-compliant DDL to append to the generated CREATE TABLE statement.

To set default create clause values for all new objects, go to the Tools > Options > Storage menu - Default Optional CREATE Clause.