Functions/Operations/Update-View.ps1
|
function Update-View { <# .SYNOPSIS Updates an existing view. .DESCRIPTION Updates an existing view. .LINK https://msdn.microsoft.com/en-us/library/ms173846.aspx .EXAMPLE Update-View -SchemaName 'rivet' 'ReadMigrations' 'AS select * from rivet.Migrations' Updates a view to read all the migrations from Rivet's Migrations table. Don't do this in real life. #> [CmdletBinding()] param( [Parameter(Mandatory=$true,Position=0)] [string] # The name of the view. $Name, [Parameter()] [string] # The schema name of the view. Defaults to `dbo`. $SchemaName = 'dbo', [Parameter(Mandatory=$true,Position=1)] [string] # The definition of the view. Everything after the `alter view [schema].[name]` clause. $Definition ) Set-StrictMode -Version 'Latest' New-Object Rivet.Operations.UpdateViewOperation $SchemaName,$Name,$Definition } |