Search code examples
sqlindexingsql-server-ce

How to check a SQL Server CE database for indexes?

Is there a way to list all SQL Server CE database table indexes, or at least for individual tables?

Solution

  • -- Retrieves information about the indexes contained in the database. SELECT * FROM INFORMATION_SCHEMA.INDEXES

    -- Retrieves all the Tables in the database including the System tables. SELECT * FROM INFORMATION_SCHEMA.TABLES

    Arjuna Chiththananda - Retrieving Schema Information of SQL CE Database