From ed5640d8b587fbcfed7dd7967f3de04b37a76f26 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 7 Apr 2024 11:06:44 +0200 Subject: Adding upstream version 4:7.4.7. Signed-off-by: Daniel Baumann --- .../source/text/sdatabase/tablewizard03.xhp | 63 ++++++++++++++++++++++ 1 file changed, 63 insertions(+) create mode 100644 helpcontent2/source/text/sdatabase/tablewizard03.xhp (limited to 'helpcontent2/source/text/sdatabase/tablewizard03.xhp') diff --git a/helpcontent2/source/text/sdatabase/tablewizard03.xhp b/helpcontent2/source/text/sdatabase/tablewizard03.xhp new file mode 100644 index 000000000..2862ca439 --- /dev/null +++ b/helpcontent2/source/text/sdatabase/tablewizard03.xhp @@ -0,0 +1,63 @@ + + + + + +Table Wizard - Set Primary Key +/text/sdatabase/tablewizard03.xhp + + +UFI: new Table Wizard page 3 + + + +
+

Table Wizard - Set Primary Key

+Specifies a field in the table to be used as a primary key. +
+ +

Create a primary key

+Select to create a primary key. Add a primary key to every database table to uniquely identify each record. For some database systems within %PRODUCTNAME, a primary key is mandatory for editing the tables. + +

Automatically add a primary key

+Select to automatically add a primary key as an additional field. + +

Use an existing field as a primary key

+Select to use an existing field with unique values as a primary key. + +

Field name

+Select the field name. + + +

Auto value

+Select to automatically insert a value and increment the field's value for each new record. The database must support automatic incrementation in order to use the Auto value feature. + +

Define primary key by several fields

+Select to create a primary key from a combination of several existing fields. + +

Available fields

+Select a field and click > to add it to the list of primary key fields. + + + +

Primary key fields

+Select a field and click < to remove it from the list of primary key fields. The primary key is created as a concatenation of the fields in this list, from top to bottom. +Table Wizard - Create table + + -- cgit v1.2.3