In this article
...
Field Name | Field Type | Description | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Label*
Default Value: SQL Server - Table List | String | Specify the name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your Pipeline. | ||||||||||||
Schema Name
Default Value: N/A | String/Expression | Specify the database schema name. Selecting a schema filters the Table name list to show only those tables within the selected schema. The property is suggestible and will retrieve available database schemas during suggest values. | ||||||||||||
Compute table graph Default Value: Deselected | Checkbox | Specify the dependents among tables and returns each table with a list of tables it has foreign key references to. The ordering of outputted tables is from least dependent to most-dependent. Note that as turning on this option will significantly slow down the Snap, it should be left as off unless you need it. | ||||||||||||
Default Value: Validate & Execute | Dropdown list |
|
Examples
In the following example, the Table List Snap retrieves all the tables under schema 'dbo' and writes it to output view.
The sample output view data is shown below:
...
Snap Pack History
Expand | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
...