blob: 4381696f630f5cda793a3dd637addfef99834c8e (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
|
<?xml version="1.0" encoding="UTF-8"?>
<!--
* This file is part of the LibreOffice project.
*
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
*
* This file incorporates work covered by the following license notice:
*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed
* with this work for additional information regarding copyright
* ownership. The ASF licenses this file to you under the Apache
* License, Version 2.0 (the "License"); you may not use this file
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
<helpdocument version="1.0">
<meta>
<topic id="textsharedexplorerdatabase05010100xml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">Index design</title>
<filename>/text/shared/explorer/database/05010100.xhp</filename>
</topic>
</meta>
<body>
<section id="indexentwurf">
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/IndexDesignDialog" id="bm_id3156410" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/.uno:DBIndexDesign" id="bm_id3149828" localize="false"/><paragraph role="heading" id="hd_id3153311" xml-lang="en-US" level="1"><link href="text/shared/explorer/database/05010100.xhp" name="Index design">Index design</link></paragraph>
<paragraph role="paragraph" id="par_id3166460" xml-lang="en-US"><ahelp hid=".uno:DBIndexDesign">The <emph>Index Design </emph>dialog allows you to define and edit the indexes for the current table.</ahelp></paragraph>
</section>
<section id="howtoget">
<embed href="text/shared/00/00000450.xhp#indexentwurf"/>
</section>
<embed href="text/shared/guide/data_tabledefine.xhp#data_tabledefine"/>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/INDEX_LIST" id="bm_id3148473" localize="false"/><paragraph role="heading" id="hd_id3149578" xml-lang="en-US" level="2">Index list</paragraph>
<paragraph role="paragraph" id="par_id3155342" xml-lang="en-US"><ahelp hid="dbaccess/ui/indexdesigndialog/INDEX_LIST">Displays a list of available indexes. Select an index from the list to edit. The details of the selected index are displayed in the dialog.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/ID_INDEX_NEW" id="bm_id3158430" localize="false"/><paragraph role="heading" id="hd_id3149795" xml-lang="en-US" level="3">New Index</paragraph>
<paragraph role="paragraph" id="par_id3150085" xml-lang="en-US"><ahelp hid="dbaccess/ui/indexdesigndialog/ID_INDEX_NEW">Creates a new index.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/ID_INDEX_DROP" id="bm_id3148642" localize="false"/><paragraph role="heading" id="hd_id3145317" xml-lang="en-US" level="3">Delete Current Index</paragraph>
<paragraph role="paragraph" id="par_id3154860" xml-lang="en-US"><ahelp hid="dbaccess/ui/indexdesigndialog/ID_INDEX_DROP">Deletes the current index.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/ID_INDEX_RENAME" id="bm_id3154285" localize="false"/><paragraph role="heading" id="hd_id3150986" xml-lang="en-US" level="3">Rename Current Index</paragraph>
<paragraph role="paragraph" id="par_id3148685" xml-lang="en-US"><ahelp hid="dbaccess/ui/indexdesigndialog/ID_INDEX_RENAME">Renames the current index.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/ID_INDEX_SAVE" id="bm_id3151245" localize="false"/><paragraph role="heading" id="hd_id3153628" xml-lang="en-US" level="3">Save Current Index</paragraph>
<paragraph role="paragraph" id="par_id3148563" xml-lang="en-US"><ahelp hid="dbaccess/ui/indexdesigndialog/ID_INDEX_SAVE">Saves the current index in the data source.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/ID_INDEX_RESET" id="bm_id3147265" localize="false"/><paragraph role="heading" id="hd_id3154924" xml-lang="en-US" level="3">Reset Current Index</paragraph>
<paragraph role="paragraph" id="par_id3154758" xml-lang="en-US"><ahelp hid="dbaccess/ui/indexdesigndialog/ID_INDEX_RESET">Resets the current index to the setting that it had when the dialog was started.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3152812" xml-lang="en-US" level="2">Index details</paragraph>
<paragraph role="paragraph" id="par_id3154938" xml-lang="en-US">As soon as you change a detail of the current index and then select another index, the change is immediately passed on to the data source. You can only leave the dialog, or select another index, if the change has been successfully acknowledged by the data source. However, you can undo the change by clicking the <emph>Reset Current Index </emph>icon.</paragraph>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/UNIQUE" id="bm_id3145171" localize="false"/><paragraph role="heading" id="hd_id3154138" xml-lang="en-US" level="3">Unique</paragraph>
<paragraph role="paragraph" id="par_id3156282" xml-lang="en-US"><ahelp hid="dbaccess/ui/indexdesigndialog/UNIQUE">Specifies whether the current index allows only unique values.</ahelp> Checking the <emph>Unique </emph>option prevents duplicate data from being entered in the field and ensures data integrity.</paragraph>
<paragraph role="heading" id="hd_id3150448" xml-lang="en-US" level="3">Fields</paragraph>
<paragraph role="paragraph" id="par_id3147085" xml-lang="en-US">The<emph> Fields</emph> area displays a list of fields in the current table. You can also select multiple fields. In order to remove a field from the selection, select the empty entry at the start of the list.</paragraph>
<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DLGINDEX_INDEXDETAILS_FIELD" id="bm_id3147230" localize="false"/><paragraph role="heading" id="hd_id3149765" xml-lang="en-US" level="3">Index field</paragraph>
<paragraph role="paragraph" id="par_id3158408" xml-lang="en-US"><ahelp hid="HID_DLGINDEX_INDEXDETAILS_FIELD">Displays a list of the fields in the current table. You can select more than one field.</ahelp><comment>i73718</comment></paragraph>
<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DLGINDEX_INDEXDETAILS_SORTORDER" id="bm_id3154910" localize="false"/><paragraph role="heading" id="hd_id3153192" xml-lang="en-US" level="3">Sort order</paragraph>
<paragraph role="paragraph" id="par_id3149561" xml-lang="en-US"><ahelp hid="HID_DLGINDEX_INDEXDETAILS_SORTORDER">Determines the sort order of the indexes.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/close" id="bm_id3145785" localize="false"/><paragraph role="heading" id="hd_id3155132" xml-lang="en-US" level="2">Close</paragraph>
<paragraph role="paragraph" id="par_id3154190" xml-lang="en-US"><ahelp hid="dbaccess/ui/indexdesigndialog/close">Closes the dialog.</ahelp></paragraph>
</body>
</helpdocument>
|
