Get-R1DataSourceTable
Get-R1DataSourceTable
SYNOPSIS
Returns the tables of a database data source.
SYNTAX
Get-R1DataSourceTable [-dataSourceName] <String> [[-catalogName] <String>] [[-schemaName] <String>]
[[-tablePattern] <String>] [<CommonParameters>]
DESCRIPTION
Returns the tables and views a database data source offers, optionally narrowed by catalog, schema or name.
EXAMPLES
Example 1
Get-R1DataSourceTable -dataSourceName 'advworks'
Returns every table of the advworks data source.
Example 2
Get-R1DataSourceTable -dataSourceName 'advworks' -schemaName 'APP' -tablePattern 'CUST%'
Returns tables in the APP schema whose name starts with CUST.
PARAMETERS
-dataSourceName
The name of the data source.
Type: String
Parameter Sets: (All)
Aliases: name
Required: True
Position: 1
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False
-catalogName
The database catalog to list tables from.
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: 2
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False
-schemaName
The database schema to list tables from.
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: 3
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False
-tablePattern
A pattern limiting which table names are returned.
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: 4
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False
CommonParameters
This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.
INPUTS
None
OUTPUTS
psRadiantOne.DatabaseTable
NOTES
Only a database data source can be listed. Naming an LDAP one is refused with “Unable to establish connection to the database”.