Utilities: Administration: Server: Database: View and Edit Data: Run Your Own SQL Query

You may run your own SQL query by typing it here. If successful, you are taken to the View Query Results page; if unsuccessful, you see the SQL error generated by your SQL server. User-entered queries cannot be sorted in the interface, in order to prevent exceptions when trying to sort on a textblob column. For sortable columns, use View Member Table, View Member Segment, or View Any Table.

WARNING Running your own SQL query can permanently alter your Aurea List Manager database. Inserting, editing or deleting data may cause ListManager to malfunction in unpredictable ways, and should be done at your own risk.

Consult a database administrator if you are uncertain about a function or query. Information about the Aurea List Manager tables is available in the Programmer's Guide.