Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Service Manager9.50

Develop > Tailoring > Data management > Fields and Keys tab > Edit a field in a table

Edit a field in a table

Note: You must use the Windows client whenever you need to add or edit a field/key in a database dictionary table.

From the System Navigator, click Tailoring > Database Dictionary.
Place the cursor in the File Name field and click Search.
From the System Definition utility overview, click the Fields tab.
Click Edit Field/Key.
If necessary, click the plus sign (+) to expand array structures.

Click a field to view its general properties, data policy, and editing rules on the right side of the window. Add or update any of the following:

Section	Field	Description
General properties	Type	You can change type if the field is one of these types: Boolean Date time Decimal Text Changing the data type can produce unpredictable results. Proceed with caution.
	Caption	Field caption
	Rename the field	You can rename the field; however, proceed with caution. Renaming a field can invalidate existing queries.
	Create (or Edit) default help on this field	Create a new Help record or edit the existing Help record.
	Search for specific help on this field in forms	You can search for an existing field help topic to apply to this field. Click Search to generate a record list of available field help topics.
Aliases	New	Click New, type a new alias name, and click OK.
	Delete	Select an existing alias and click to remove it.
	Rename	Select an existing alias, click Rename, type a new alias name, and click OK.
Data policy	Default value	A default value for the field is optional.
	Data encrypted (encryption status).	Select or clear the checkbox.
	Match table Match field	Define or enforce foreign key relationships. For example, you can specify that the contact.name field in one table must match a valid contact.name field from another table.
Editing rules	Mandatory	Type true if the field must appear on the form.
	Validation rule	Specify a condition that is true or false.
	Read-only	Type true if users cannot change the field value.
	Invisible	Type true if the field should be invisible.
	Available in lists	Type true if the field should appear in a list.

If you make any updates, click Save.

Tip: You can edit any field or key directly from the System Navigator. Double-click the field or key to view the details with the System Definition utility.

Send Help Center feedback