I want to write the query to display the index within the database and its creation date.
Here is the query:
We can test it with below cases:
After all the tables are created, we run the query within the database. Here is the result
I also tried to run the query in the adventure work sample database. Interestingly, the table value function also consider as index and show up in the sys.indexes table.