Displaying the SQL query for a view when previewing in Drupal 7 Views

Written by Scott Mitchell

When working in the Views module, you may want to preview the SQL that is generated by the view. This is for the code savvy or the ones looking to be and would like to see the SQL generated for either debugging or further development of their views. Sometimes seeing the code can help understand how the view works in case it needs further tweaking. Showing the SQL query for a View's preview is done with the following instructions.

Showing the SQL query for a view preview in Drupal 7 Views

  1. Log into your Drupal 7 admin dashboard.
  2. From the top menu bar, locate the Structure option and click it.
    structure
  3. Click on the Views option to move to the next screen.
    structure-views
  4. You are now on the Views list screen. Look to the upper right and you will see two tabs. Click on the one that is labeled Settings.
    view-settings
  5. Once you get to the Settings page scroll down to the bottom of the screen to the Live Preview Settings and find the checkbox labeled Show the SQL query. Click the checkbox to enable the feature.
    set-query-preview
  6. Once finished, click on the Save Configuration button at the bottom. Preview one of your views and you will now see the SQL code.
    show-query-after
Like this Article?

Login to comment.

Support Center Login

Views Module Tutorial
1. Introduction to Views in Drupal 7
2. Creating your first View in Drupal 7
3. Enabling a view in Drupal 7 Views
4. Creating a block display for a View in Drupal 7
5. Changing the title for a view in the Drupal 7 Views Module
6. How to link to a view within a menu in Drupal 7 Views module
7. How to disable caching in Drupal 7 Views module
8. Displaying the SQL query for a view when previewing in Drupal 7 Views

Your Opinion Matters

... but we need to know what you're thinking!

I'm Scott Mitchell, your friendly Community Support technician, and I wrote the article you're looking at now. I like to think it's perfect, but I'm sure you have some suggestions. Please, let me know what they are!

Feedback
Your Email Address
Because we'd like to talk with you!

Latest Questions

If you need some help, submit your question to our Community!
We guarantee a response within 60 minutes (8am - 9pm EST, Monday - Friday)
Ask a Question!
Recent Questions
  1. I can't access my website
  2. we-creation.com server down
  3. How do I delete the DNS entry?
Browse other questions

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!