Navigation:  Advantage SQL > System Procedures > Procedures >

sp_mgGetTableIndexes

Advantage SQL Engine

Previous pageReturn to chapter overviewNext page

Returns a result set containing all indexes opened on the specified table.

Syntax

EXECUTE PROCEDURE sp_mgGetTableIndexes( TableName,Character,255 )

Parameters

TableName (I)

Full qualified path to the table.

IndexName (O)

Full qualified path to the index file.

Remarks

Tables can have zero or more index files associated with them. This procedure returns the fully qualified path to the index files associated with the table.

Note With Advantage Local Server, sp_mgGetTableIndexes will only return indexes opened on this table in the instance of Advantage Local Server currently loaded into memory. Information about indexes opened on the table in other instances of the Advantage Local Server will not be returned.

Example

EXECUTE PROCEDURE sp_mgGetTableIndexes( '\\server\share\data\table.adt' );

See Also

sp_mgGetAllIndexes

sp_mgGetAllTables

sp_mgGetUserIndexes