Clustered columnstore index in sql server 2014

Question

How can we get the list of clustered columnstore index in a database in sql server 2014

Answer 1

Try the below:

Select object_name(object_id),* From sys.indexes where type=5

---

Please mark this reply as answer if it solved your issue or vote as helpful if it helped.
 [Blog]

Answer 2

As databases are growing we also need to track which tables has clustered and nonclustered columnstore indexes.
Sys.indexes has added two more type values to find tables which has columnstore indexes type 5 for CLUSTERED COLUMNSTORE