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?
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP