Hi all,
can u please tell me How to get index column names in a database.

Thanks&Regards,

raavi

CREATE INDEX index_name ON tbl_name (index_col_name)

Which database system are you using?

A few databases implement the INFORMATION_SCHEMA views, but almost all of them require you to use a database engine specific query. Finding out which columns are indexed is often one of the biggest challenges, since nearly every database engine has a different concept of how to do that job.

-PatP