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 will be taken to the View Query Results page; if unsuccessful, you will 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.

 

NOTE: WARNING Running your own SQL query can permanently alter your ListManager 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 ListManager tables is available in the Programmer's Guide.