Indexes on a table

[dcarr]

Hello guys. Does anyone know how to check how many indexes have been created on a table? I am attempting to discover why a database is so big in size and think this may be contributing to it.
Thanks

 

[Mile-O]

Have you compacted your database?

 

[dcarr]

Hello, thanks for the prompt reply. I have compacted the database and this reduced the size of the DB in MB.

 

[dcarr]

Sorry, but it is still really big in size after the compact

 

[Rich]

Do you have graphics in the db, backround for forms etc?

 

[dcarr]

No, no graphics. There are six forms that are no longer in use. What typically takes up most space in a database? Apart from the obvious huge tables, etc?
Thanks

 

[dcarr]

So is there anyway to simply find out what indexes if any exist on the database?

 

[FoFa]

If you use Database Documenter (or whatever it is called) it will list the indexes on a table.