Syntax conventions

Syntax formatting conventions are summarized in the following table. Examples combining these elements follow.

Key

Definition

variable

Variables (words standing for values that you fill in) are in italics.

{ } 

Curly braces mean that you must choose at least one of the enclosed options. Do not include braces in the command.

[ ] 

Brackets mean that you may choose or omit enclosed options. Do not include brackets in the command.

| 

Vertical bars mean that you may choose no more than one option (enclosed in braces or brackets).

, 

Commas mean that you may choose as many options as you need (enclosed in braces or brackets). Separate your choices with commas, to be typed as part of the command.

Commas may also be required in other syntax contexts.

( ) 

Parentheses are to be typed as part of the command.

... 

An ellipsis (three dots) means that you may repeat the last unit as many times as you need. Do not include ellipses in the command.

Obligatory choices

Optional choices

Repeating elements

An ellipsis ( . . . ) means that you may repeat the last unit as many times as you need. For the alter replication definition command, for example, you can list one or more columns and their datatypes for either the add clause or the add searchable columns clause:

alter replication definition replication_definition
{add column datatype [, column datatype]... |
 add searchable columns column [, column]... |
 replicate {minimal | all} columns}