The Schema Browser is a user friendly and efficient way to view column definitions for Tables and Views:

• Access the Schema Browser

• View and Filter Table Information

• Run / Quick Run Table

• Schema Browser Tabs

To access the Schema Browser, select the Schema Browser tab from beneath the Query Editor:  

Open

To view table information for a Schema, select a Table or View from available list. The associated columns and information (Data Type, Size, etc.) will appear below the Tables / Views by default:   

Open

Note: A database View in the context of the Schema Browser is a searchable object in a database that is defined by a query. Although a view does not store data, a view could be considered a "virtual table" that can be queried and viewed like a real table. 

An intuitive Filter is available to assist in finding the right table for selection. This is especially helpful when working with a Schema that has a high volume of Tables / Views. 

To use this feature, simply begin typing in the Filter box, and results will dynamically filter for you acting as a wildcard (the full name of a Table / View does not have to be entered):

To quickly run a Select * statement (brings back all data for that table) on a table listed as a Table / View, simply select the table and then select Run: 

Open

The Select * statement will automatically fill into the Query Editor, and the data results for the statement will appear in the Query Results: 

Open

The Quick Run option allows for creating parameters around what data results should be returned - without needing to write any SQL! Instead of automatically running a Table as a Select *, the Quick Run allows for specifying which Columns should be returned, and what parameters (filters) on the data should be applied:

Open

Note: For more information on Quick Run and using Parameters, check out the Help Center article Overview of Running a Query

The Schema Browser has several tabs lining the bottom that can be used to navigate additional information (like Primary Keys, Constraints, and Triggers) about the selected Table / View: 

Open