VFP 愛用者社區

[cathysia]

我想把一张表里面全部的索引和里面的关键rule列出来，可是找不到相关的命令。

手抄就太笨了。

表的结构就能用 list structure列出来， 那么索引是否也能列出来呢？

[syntech]

查一下 KEY()

-----------------------
Example
The following example opens the customer table in the testdata database. FOR ... ENDFOR is used to create a loop in which KEY( ) is used to display the index expression of each index tag in the customer structural index. The name of each structural index tag is displayed with its index expression.
CLOSE DATABASES
OPEN DATABASE (HOME(2) + 'Data\testdata')
USE Customer && Open customer table
CLEAR

FOR nCount = 1 TO 254
IF !EMPTY(TAG(nCount)) && Checks for tags in the index
? TAG(nCount) + ' ' && Display tag name
?? KEY(nCount) && Display index expression
ELSE
EXIT && Exit the loop when no more tags are found
ENDIF
ENDFOR

[小桑•無痕]

MSDN Help

ATAGINFO( ) Function
Creates an array that contains information about the names, number, and types of indexes and key expressions.

ATagInfo(ArrayName [,cCDXName [, nWorkArea | cTableAlias]])
Parameters
ArrayName
Specifies the name of the array to be created. Visual FoxPro creates the array if it does not already exist.
cCDXName
Specifies the name of the compound index file for which ATAGINFO( ) returns information. If you specify the empty string ("") for cCDXName, ATAGINFO( ) returns the number of tags in all open .cdx files and all open .idx files for the selected table.
nWorkArea
Optional. Specifies the work area containing the table for which ATAGINFO( ) returns information.
cTableAlias
Optional. Specifies the alias of the table for which ATAGINFO( ) returns information. If you omit cTableAlias and nWorkArea the function uses the table in the current workarea.
Return Value
Numeric

[bin1x]

dbgetprop()應該會有用
不過會查表查半天
如果只是單純的index order
disp status 就可以看了

[cathysia]

谢谢两位，问题解决了，^_^