|
sp_mgGetAllIndexes Advantage SQL Engine |
|
|
|
sp_mgGetAllIndexes Advantage SQL Engine |
|
|
Returns a result set containing all the index files that are currently opened on the server.
Syntax
EXECUTE PROCEDURE sp_mgGetAllIndexes()
Parameters
IndexName (O) |
Full path and file name of each index file currently open on the server. |
Remarks
This procedure returns the fully qualified path names of all index files that are opened on the server by all users.
Note With Advantage Local Server, sp_mgGetAllIndexes will only return information about indexes opened by the instance of Advantage Local Server currently loaded into memory. Information about indexes opened by other instances of Advantage Local Server will not be returned.
Example
EXECUTE PROCEDURE sp_mgGetAllIndexes();
See Also