You are here: Utilities > Administration > Server > Utilities: Administration: Server: Database Administration: Run Your Own SQL Query'

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.

 

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.

More

 

1. Utilities: Administration: Server: Database Administration

2. Utilities: Administration: Server: Database Administration: View and Edit Data

1. Utilities: Administration: Server: Database Administration: View Member Table

2. Utilities: Administration: Server: Database Administration: View Table

3. Utilities: Administration: Server: Database Administration: View Segment

4. Utilities: Administration: Server: Database Administration: Run Your Own SQL Query

5. Utilities: Administration: Server: Database Administration: View Query Results

6. Utilities: Administration: Server: Database Administration: View Row

3. Utilities: Administration: Server: Database Administration: Add/Remove Member Columns

1. Utilities: Administration: Server: Database Administration: Add Member Column

2. Utilities: Administration: Server: Database Administration: Add Member Column: Wizard

3. Utilities: Administration: Server: Database Administration: Delete Member Column

4. Utilities: Administration: Server Database: Demographic Definitions

1. Utilities: Administration: Server Database: Demographic Definitions: New Definition

5. Utilities: Administration: Server: Database Administration: Insert Row