Index property view – PB Docs 126

Index property view

Description

Add as many single- or multivalued indexes to a database table
as you need.

If your back-end DBMS requires additional information to define
an index, additional options display. For example, in Adaptive Server
Enterprise, you must specify whether the index is clustered. SQL
Anywhere only requires the information described here.

Options

Table

The name of the table.

Owner

The owner of the table.

Index

Enter a name for the index you are creating.

Columns

Select the names of the columns in the table on which you
want to create the index. The selected column names display in the
Order box. To deselect a selected column, clear its check box..

Unique

Select the type of index you want. The default is Unique (the
indexed columns must contain unique values). To allow duplicates, clear
the check box.

Ascending

Select if you want the index in Ascending order.

See also


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x