Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Find what table a specific index belongs to

Tags:

sql

sql-server

sql-server-2005

If I have the name of an index, what query can I use to find what table the index belongs to?

like image 414
Patrick Avatar asked Sep 11 '09 19:09

Patrick

1 Answers

SELECT OBJECT_NAME(object_id) FROM sys.indexes WHERE name = '...'
like image 77
Lukasz Lysik Avatar answered Sep 29 '22 20:09

Lukasz Lysik
Sign in to Comment

Related questions

Index for nullable column
"to_tsquery" on tsvector yields different results when using "simple" and "english"?
SQLite: Get Total/Sum of Column
Check statistics targets in PostgreSQL
How to declare VARCHAR variables in MSSQL
Oracle DB & SQL Developer: "Error report: execution completed with warning" - How do I *see* the warning?
Creating trigger for table in MySQL database (syntax error)
Postgres math expression calculcated for each row in table
What does this query mean?
SQL Sort Order with Null values last
How do I remove redundant namespace in nested query when using FOR XML PATH
How to write UNION in Doctrine 2.0
java hibernate: selecting the discriminator column in polymorphic hql query
JOOQ & transactions
Select all parents or children in same table relation SQL Server
What is SRID 0 for geometry columns?
SQL Server WITH statement
Difference between Session and Connection in SQL Server
What SQL would I need to use to list all the stored procedures on an Oracle database?
Understanding Update and Delete Rules for Relationships in SSMS 2008

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!