Test the database view
Verify that the database view works correctly.
Before you begin
Role required: admin.
About this task
Procedure
-
Navigate to All > System Definition > Database Views.
-
Select the database view that you want to test.
-
Test the view by clicking the Try It related link.
Note: If you do not see the Try It link, the tables necessary for the view do not exist. If this problem occurs, it is possible that you did not activate the necessary plugins to create the supporting tables.
The database view runs and a list of items is displayed. If you have specified fields in the View Fields related list for each table, the output is limited to those fields. If you specified view fields and the view does not display correctly, review the View Fields related list for each table and ensure that you include fields from the Where clause.
Output of the sample Incident Metrics database view
[Omitted image "database-view-output.png"] Alt text: Output of the sample Incident Metrics database view
What to do next
To use the database view in a data visualization, select it from the data sources. Database views are listed under tables.
[Omitted image "db-view-selection.png"] Alt text: The Incident Metric database view selected for a visualization
You can create any visualization type using the database view. This example shows the database view visualized as vertical bar.
[Omitted image "db-view-used-in-data-vis.png"] Alt text: The incident metric database view visualized as a vertical bar grouped by escalation
Parent Topic:Joining tables using database views
Previous topic:Configuring the number of records to return
---
title: Test the database view
description: Verify that the database view works correctly.
locale: en-US
canonical_url: https://www.servicenow.com/docs/r/australia/platform-administration/table-administration-and-data-management/t\_TestTheDatabaseView.html
release: australia
product: Table Administration and Data Management
classification: table-administration-and-data-management
topic_type: task
last_updated: "2026-09-10"
reading_time_minutes: 1
breadcrumb: [Joining tables, Work with database views, Table admin, Tables and data, Configure core features, Administer the ServiceNow AI Platform]
---
# Test the database view
Verify that the database view works correctly.
## Before you begin
Role required: admin.
## About this task
## Procedure
1. Navigate to **All** > **System Definition** > **Database Views**.
2. Select the database view that you want to test.
3. Test the view by clicking the **Try It** related link.
**Note:** If you do not see the Try It link, the tables necessary for the view do not exist. If this problem occurs, it is possible that you did not activate the necessary plugins to create the supporting tables.
The database view runs and a list of items is displayed. If you have specified fields in the **View Fields** related list for each table, the output is limited to those fields. If you specified view fields and the view does not display correctly, review the **View Fields** related list for each table and ensure that you include fields from the **Where clause**.
## Output of the sample Incident Metrics database view
\[Omitted image "database-view-output.png"\] Alt text: Output of the sample Incident Metrics database view
## What to do next
To use the database view in a data visualization, select it from the data sources. Database views are listed under tables.
\[Omitted image "db-view-selection.png"\] Alt text: The Incident Metric database view selected for a visualization
You can create any visualization type using the database view. This example shows the database view visualized as vertical bar.
\[Omitted image "db-view-used-in-data-vis.png"\] Alt text: The incident metric database view visualized as a vertical bar grouped by escalation
**Parent Topic:**[Joining tables using database views](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/platform-administration/table-administration-and-data-management/c_CreatingDatabaseViews.md)
**Previous topic:**[Configuring the number of records to return](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/platform-administration/table-administration-and-data-management/c_SpecifyTheNumberOfRecordsToReturn.md)
**Next topic:**[Displaying function results in a database view](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/platform-administration/table-administration-and-data-management/displaying-function-results-in-a-database-view.md)
| title | Test the database view |
| description | Verify that the database view works correctly. |
| locale | en-US |
| canonical_url | https://www.servicenow.com/docs/r/australia/platform-administration/table-administration-and-data-management/t\_TestTheDatabaseView.html |
| release | australia |
| product | Table Administration and Data Management |
| classification | table-administration-and-data-management |
| topic_type | task |
| last_updated | 2026-09-10 |
| reading_time_minutes | 1 |
| breadcrumb | Joining tablesWork with database viewsTable adminTables and dataConfigure core featuresAdminister the ServiceNow AI Platform |