TransWikia.com

How to get the list of foreign key together with the index name on that foreign key?

Database Administrators Asked by anony mous on October 28, 2021

I am using this query to list all the foreign key, but I also need to have the index name on that foreign key.

select a.*
from INFORMATION_SCHEMA.TABLE_CONSTRAINTS as a
where a.CONSTRAINT_TYPE = 'FOREIGN KEY';

How to get a list of the foreign key together with the index name on that foreign key?

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP