New-R1SchemaDerivedView
New-R1SchemaDerivedView
SYNOPSIS
Derives a view from a single attribute of a table.
SYNTAX
New-R1SchemaDerivedView [-schemaName] <String> [-sourceTable] <String> [-field] <String> [-WhatIf] [-Confirm]
[<CommonParameters>]
DESCRIPTION
Creates a view derived from one attribute of an existing table or view, together with the relationship joining it back to its source. Both are returned.
EXAMPLES
Example 1
New-R1SchemaDerivedView -schemaName 'default' -sourceTable 'APP.CUSTOMERS' -field 'address'
Derives an address view from the customers table.
PARAMETERS
-schemaName
The name of the schema.
Type: String
Parameter Sets: (All)
Aliases: name
Required: True
Position: 1
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False
-sourceTable
The table or view to work from.
Type: String
Parameter Sets: (All)
Aliases:
Required: True
Position: 2
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False
-field
The single attribute of the source table to build the derived view from.
Type: String
Parameter Sets: (All)
Aliases:
Required: True
Position: 3
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False
-WhatIf
Shows what would happen if the cmdlet runs. The cmdlet is not run.
Type: SwitchParameter
Parameter Sets: (All)
Aliases: wi
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
-Confirm
Prompts you for confirmation before running the cmdlet.
Type: SwitchParameter
Parameter Sets: (All)
Aliases: cf
Required: False
Position: Named
Default value: None
Accept pipeline input: False
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.