In this article, we will describe how to run SQL queries using the DNN SQL Console feature.
The SQL Console feature allows an administrator to run SQL queries using the persona bar without having to use an external tool such as SSMS.
Note: This is an advanced feature that could cause damage to the Database structure if not used properly; If you are not proficient in SQL, avoid using it.
- Open the Persona bar.
- Navigate to Settings -> Site Settings -> SQL Console.
- Write the desired Query.
In the example below the query used was "Select * from portals".
- Click on the Run Script button. The output will be displayed at the bottom of the page.
- If you want to export the output, click on the Export button.