Invoke-Ddl

Executes a DDL statement against the database.

Syntax

Invoke-Ddl [-Query] <String> [<CommonParameters>]

Description

The Invoke-Ddl function is used to update the structure of a database when none of Rivet's other operations will work.

Parameters

Name Type Description Required? Pipeline Input Default Value
Query String true true (ByValue)

EXAMPLE 1

Invoke-Ddl -Query 'create table rivet.Migrations ( id int not null )'

Executes the create table syntax above against the database.