Edit a record key

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)`

Applies to User Roles:

System Administrator

We recommend that you do not change the data type for any unique keys in out–of–box tables.

To edit a record key:

Click Tailoring > Database Dictionary.

Type a file name and then use search to find the table.

Select a record to edit.

Click the Keys tab to edit.

Click a key to view or change its general properties.

Change the key type as needed. Proceed with caution if you change the key type to a more restrictive value.
Click Add or Remove to change the content of the key.
For IR keys, you can also edit the associated IR properties.

To add a key, click New. A new key position appears in the Keys tree structure.

To remove a key, click Delete.

If a key is eligible to change position, click Up or Down.

Related concepts

Related tasks