Database Input Property Sheet SQL Query Tab

This tab is only available for database inputs. It allows you to edit the default SQL query to help you create your data structure columns.

The following tools are available on the SQL Query tab:

Tool	Description
	Retrieve Columns by Parsing Query — Parses the query you have specified in the textbox using the SQL Editor. The columns of the query are automatically created in the Data Structure Columns tab of the database input and their parent tables or views are displayed in the Data Structure Source Objects tab. You can also click this tool to update data structure columns and source tables when you have modified source expressions of data structure columns.
	Edit SQL Query — Opens the query in the SQL editor that helps you select PDM objects (tables, views, columns, procedures, and users) to build the SQL query script.

Tool

Description

Retrieve Columns by Parsing Query — Parses the query you have specified in the textbox using the SQL Editor. The columns of the query are automatically created in the Data Structure Columns tab of the database input and their parent tables or views are displayed in the Data Structure Source Objects tab. You can also click this tool to update data structure columns and source tables when you have modified source expressions of data structure columns.

Edit SQL Query — Opens the query in the SQL editor that helps you select PDM objects (tables, views, columns, procedures, and users) to build the SQL query script.