This snippet lists all modules with associated fields, so you can review their status.

SELECT * FROM `system` WHERE type = 'module';

Most of the rows of the system table will be modules but themes and theme engines are also included. This snippet just filters out the themes and theme engines from the listing.