title

Specify Naming Conventions (Schema Generation Wizard) (Analysis Services - Multidimensional Data) | Microsoft Docs

ms.custom

ms.date

06/13/2017

ms.prod

sql-server-2014

ms.reviewer

ms.technology

analysis-services

ms.topic

conceptual

f1_keywords

sql12.asvs.schemagenwizard.namingconventions.f1

ms.assetid

02d830ea-5b1f-4485-9f94-d64b8bea592b

author

minewiskan

ms.author

owend

manager

craigg

Specify Naming Conventions (Schema Generation Wizard) (Analysis Services - Multidimensional Data)

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.