Merge-R1SchemaObject
Merge-R1SchemaObject
SYNOPSIS
Merges tables and views into a single view.
SYNTAX
Merge-R1SchemaObject [-schemaName] <String> [-sourceTable] <String> [-mergedViewName] <String>
[-objectsToMerge] <String[]> [-WhatIf] [-Confirm] [<CommonParameters>]
DESCRIPTION
Merges the named tables and views into one new view, and returns the view as created.
EXAMPLES
Example 1
Merge-R1SchemaObject -schemaName 'default' -sourceTable 'APP.CUSTOMERS' -mergedViewName 'APP.ALLCUSTOMERS' -objectsToMerge 'APP.LEADS', 'APP.PROSPECTS'
Merges two objects into a new view based on 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
-mergedViewName
The name to give the merged view.
Type: String
Parameter Sets: (All)
Aliases:
Required: True
Position: 3
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False
-objectsToMerge
The tables and views to merge into the new view.
Type: String[]
Parameter Sets: (All)
Aliases:
Required: True
Position: 4
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.