Partilhar via


Specify Naming Conventions (Schema Generation Wizard) (SSAS)

Use the Specify Naming Conventions page to define the naming conventions that the Schema Generation Wizard uses when creating schema objects.

Options

  • Option
    Specify the naming conventions for the wizard to use. The following table describes the options you can specify.

    Option Description

    Separator

    Specifies the character that separates words in an object name. In the Value column, select Underscore, Space, or None. The default is Underscore.

    Primary key column prefix

    Specifies the string to prefix the name of each primary key column. The default is PK.

    Foreign key column prefix

    Specifies the string to prefix the name of each foreign key column. The default is FK.

    Attribute name suffix

    Specifies the string to be appended to the name of each attribute column. The default is Name.

    Custom rollup suffix

    Specifies the string to be appended to the name of each rollup column. The default is CustomRollup.

    Custom rollup Properties suffix

    Specifies the string to be appended to the name of each rollup property column. The default is CustomRollupProperties.

    Unary operator suffix

    Specifies the string to be appended to the name of each unary operator column. The default is UnaryOperator.

  • Value
    Specify a value for the option specified in Option that you want to use when the schema is generated.

See Also

Reference

Schema Generation Wizard F1 Help (SSAS)
Analysis Services Wizards (SSAS)

Help and Information

Getting SQL Server 2005 Assistance