Hi,
Can anyone post any code about how I would interrogate a database in ODBC to gather details of indices per table or for a particular table in the ODBC database??
Just can't fathom it...
Getting info on Indices using ODBC
Re: Getting info on Indices using ODBC
Hi,
this has nothing to do with ODBC it has to do with the database behind.
Without knowledge of the database behind no one can tell you the SQL syntax for getting these
informations.
Bernd
this has nothing to do with ODBC it has to do with the database behind.
Without knowledge of the database behind no one can tell you the SQL syntax for getting these
informations.
Bernd
-
Iron Saint
- New User
- Posts: 1
- Joined: Sun Dec 28, 2014 12:21 am
Re: Getting info on Indices using ODBC
Hello Duffer123,
You can execute a SELECT statement similar to SQLite's "select * from sqlite_master" on any database. The resultant data set will give you the information you're looking for.
For example, on Oracle you can use "SELECT * FROM user_indexes WHERE table_name = 'A_TABLE_NAME'" to retrieve the index metadata.
Note that other databases, such as DB2 or SQL Server, have slightly different ways of retrieving metadata so you will have to taylor your code specifically to that database.
Cheers,
IS
You can execute a SELECT statement similar to SQLite's "select * from sqlite_master" on any database. The resultant data set will give you the information you're looking for.
For example, on Oracle you can use "SELECT * FROM user_indexes WHERE table_name = 'A_TABLE_NAME'" to retrieve the index metadata.
Note that other databases, such as DB2 or SQL Server, have slightly different ways of retrieving metadata so you will have to taylor your code specifically to that database.
Cheers,
IS