| Tag Link | [Database_SchemaNames] ... | Category | Database |
|---|---|---|---|
| Type | Container | Source Available | No |
| Support | Preferred | Version | 6.0.2 |
| Change | Unchanged | Data Source | JDBC |
| Output Type | None | Security | None |
| Implementation | LCAPI | Sets | Lasso 8.5, Lasso 8.0, Lasso 7.0, Lasso 6.0 |
[Database_SchemaNames] ... [/Database_SchemaNames] repeats for every schema available to the current user. The [Database_SchemaNameItem] tag is used inside the container tags to display each schema name. Available only for JDBC data sources that support named schema ownership.
[Database_SchemaNames]
[Database_SchemaNameItem]
[/Database_SchemaNames]
| Required Parameters | |
|---|---|
| Database Name | The name of a Lasso |
To return the names of all available schemas:
Use the [Database_SchemaNames] ... [/Database_SchemaNames] tags with an enclosed [Database_SchemaNameItem] tag. The following example lists all the schemas that are available to the current user.
[Database_SchemaNames:'Database_Name']
<br>[Database_SchemaNameItem]
[/Database_SchemaNames]
<br>SchemaName1
<br>SchemaName2