| Tag Link | [Database_SchemaNameItem] | Category | Database |
|---|---|---|---|
| Type | Substitution | Source Available | No |
| Support | Preferred | Version | 6.0.2 |
| Change | Unchanged | Data Source | JDBC |
| Output Type | String | Security | None |
| Implementation | LCAPI | Sets | Lasso 8.5, Lasso 8.0, Lasso 7.0, Lasso 6.0 |
When used inside [Database_SchemaNames] ... [/Database_SchemaNames] container tags,
[Database_SchemaNameItem] returns the name of the current schema. Available only for JDBC data sources that support named schema ownership.
[Database_SchemaNames]
[Database_SchemaNameItem]
[/Database_SchemaNames]
No Parameters Required.
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