Hi all,
can u please tell me How to get index column names in a database.
Thanks&Regards,
raaviCREATE 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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment