Search found 1 match

by Iron Saint
Sun Dec 28, 2014 12:40 am
Forum: Coding Questions
Topic: Getting info on Indices using ODBC
Replies: 2
Views: 1520

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 ...