< Back
Clear-DaterpillarSchema
Post
NAME Clear-DaterpillarSchema
SYNOPSIS
Drops all objects (tables, views, procedures, triggers, etc.).
SYNTAX
Clear-DaterpillarSchema [-ConnectionType] {SQL | TSQL | MySQL | SQLite} [[-Host] <string>] [[-User] <string>]
[[-Password] <string>] [[-Database] <string>] [[-MigrationsDirectory] <string>] [-ConnectionString <string>]
[-FlywayFilePath <string>] [-InpuObject <string>] [-Timeout <int>] [<CommonParameters>]
DESCRIPTION
This cmdlet drops all objects (tables, views, procedures, triggers, etc.).
PARAMETERS
-ConnectionType <Language>
The SQL language of the script.
Possible values: SQL, TSQL, MySQL, SQLite
Required? true
Position? 1
Default value SQL
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-lang <Language>
The SQL language of the script.
Possible values: SQL, TSQL, MySQL, SQLite
This is an alias of the ConnectionType parameter.
Required? true
Position? 1
Default value SQL
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-type <Language>
The SQL language of the script.
Possible values: SQL, TSQL, MySQL, SQLite
This is an alias of the ConnectionType parameter.
Required? true
Position? 1
Default value SQL
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-connection-type <Language>
The SQL language of the script.
Possible values: SQL, TSQL, MySQL, SQLite
This is an alias of the ConnectionType parameter.
Required? true
Position? 1
Default value SQL
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-MigrationsDirectory <string>
The absolute-path of the directory that host the migration scripts.
Required? false
Position? 6
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-path <string>
The absolute-path of the directory that host the migration scripts.
This is an alias of the MigrationsDirectory parameter.
Required? false
Position? 6
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-fullname <string>
The absolute-path of the directory that host the migration scripts.
This is an alias of the MigrationsDirectory parameter.
Required? false
Position? 6
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-sql <string>
The absolute-path of the directory that host the migration scripts.
This is an alias of the MigrationsDirectory parameter.
Required? false
Position? 6
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-FlywayFilePath <string>
The absolute-path of the flyway executable file.
Required? false
Position? named
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-flyway <string>
The absolute-path of the flyway executable file.
This is an alias of the FlywayFilePath parameter.
Required? false
Position? named
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-Timeout <int>
The operation timeout interval in seconds. Defaults to 5 minutes.
Required? false
Position? named
Default value 0
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-InpuObject <string>
The absolute-path of the directory that host the migration scripts.
Required? false
Position? named
Default value
Accept pipeline input? true (ByValue)
Accept wildcard characters? false
-Host <string>
The server address.
Required? false
Position? 2
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-h <string>
The server address.
This is an alias of the Host parameter.
Required? false
Position? 2
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-User <string>
The authorized user.
Required? false
Position? 3
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-u <string>
The authorized user.
This is an alias of the User parameter.
Required? false
Position? 3
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-Password <string>
The database password.
Required? false
Position? 4
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-p <string>
The database password.
This is an alias of the Password parameter.
Required? false
Position? 4
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-Database <string>
The database name.
Required? false
Position? 5
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-d <string>
The database name.
This is an alias of the Database parameter.
Required? false
Position? 5
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-ConnectionString <string>
The database connection-string. Must be formatted as <key>=<value>
Required? false
Position? named
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-c <string>
The database connection-string. Must be formatted as <key>=<value>
This is an alias of the ConnectionString parameter.
Required? false
Position? named
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-connstr <string>
The database connection-string. Must be formatted as <key>=<value>
This is an alias of the ConnectionString parameter.
Required? false
Position? named
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
Acklann.Daterpillar.Language
The SQL language of the script.
System.String
The absolute-path of the directory that host the migration scripts.
System.String
The absolute-path of the flyway executable file.
System.Int32
The operation timeout interval in seconds. Defaults to 5 minutes.
System.String
The absolute-path of the directory that host the migration scripts.
System.String
The server address.
System.String
The authorized user.
System.String
The database password.
System.String
The database name.
System.String
The database connection-string. Must be formatted as <key>=<value>
OUTPUTS
---------- EXAMPLE 1 ----------
Clear-DaterpillarSchema SQLite 'C:/app/db.sqlite'
This will remove all table from the schema.
RELATED LINKS
https://github.com/Ackara/Daterpillar
https://flywaydb.org/documentation/commandline/clean
SYNOPSIS
Drops all objects (tables, views, procedures, triggers, etc.).
SYNTAX
Clear-DaterpillarSchema [-ConnectionType] {SQL | TSQL | MySQL | SQLite} [[-Host] <string>] [[-User] <string>]
[[-Password] <string>] [[-Database] <string>] [[-MigrationsDirectory] <string>] [-ConnectionString <string>]
[-FlywayFilePath <string>] [-InpuObject <string>] [-Timeout <int>] [<CommonParameters>]
DESCRIPTION
This cmdlet drops all objects (tables, views, procedures, triggers, etc.).
PARAMETERS
-ConnectionType <Language>
The SQL language of the script.
Possible values: SQL, TSQL, MySQL, SQLite
Required? true
Position? 1
Default value SQL
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-lang <Language>
The SQL language of the script.
Possible values: SQL, TSQL, MySQL, SQLite
This is an alias of the ConnectionType parameter.
Required? true
Position? 1
Default value SQL
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-type <Language>
The SQL language of the script.
Possible values: SQL, TSQL, MySQL, SQLite
This is an alias of the ConnectionType parameter.
Required? true
Position? 1
Default value SQL
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-connection-type <Language>
The SQL language of the script.
Possible values: SQL, TSQL, MySQL, SQLite
This is an alias of the ConnectionType parameter.
Required? true
Position? 1
Default value SQL
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-MigrationsDirectory <string>
The absolute-path of the directory that host the migration scripts.
Required? false
Position? 6
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-path <string>
The absolute-path of the directory that host the migration scripts.
This is an alias of the MigrationsDirectory parameter.
Required? false
Position? 6
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-fullname <string>
The absolute-path of the directory that host the migration scripts.
This is an alias of the MigrationsDirectory parameter.
Required? false
Position? 6
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-sql <string>
The absolute-path of the directory that host the migration scripts.
This is an alias of the MigrationsDirectory parameter.
Required? false
Position? 6
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-FlywayFilePath <string>
The absolute-path of the flyway executable file.
Required? false
Position? named
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-flyway <string>
The absolute-path of the flyway executable file.
This is an alias of the FlywayFilePath parameter.
Required? false
Position? named
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-Timeout <int>
The operation timeout interval in seconds. Defaults to 5 minutes.
Required? false
Position? named
Default value 0
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-InpuObject <string>
The absolute-path of the directory that host the migration scripts.
Required? false
Position? named
Default value
Accept pipeline input? true (ByValue)
Accept wildcard characters? false
-Host <string>
The server address.
Required? false
Position? 2
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-h <string>
The server address.
This is an alias of the Host parameter.
Required? false
Position? 2
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-User <string>
The authorized user.
Required? false
Position? 3
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-u <string>
The authorized user.
This is an alias of the User parameter.
Required? false
Position? 3
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-Password <string>
The database password.
Required? false
Position? 4
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-p <string>
The database password.
This is an alias of the Password parameter.
Required? false
Position? 4
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-Database <string>
The database name.
Required? false
Position? 5
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-d <string>
The database name.
This is an alias of the Database parameter.
Required? false
Position? 5
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-ConnectionString <string>
The database connection-string. Must be formatted as <key>=<value>
Required? false
Position? named
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-c <string>
The database connection-string. Must be formatted as <key>=<value>
This is an alias of the ConnectionString parameter.
Required? false
Position? named
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-connstr <string>
The database connection-string. Must be formatted as <key>=<value>
This is an alias of the ConnectionString parameter.
Required? false
Position? named
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
Acklann.Daterpillar.Language
The SQL language of the script.
System.String
The absolute-path of the directory that host the migration scripts.
System.String
The absolute-path of the flyway executable file.
System.Int32
The operation timeout interval in seconds. Defaults to 5 minutes.
System.String
The absolute-path of the directory that host the migration scripts.
System.String
The server address.
System.String
The authorized user.
System.String
The database password.
System.String
The database name.
System.String
The database connection-string. Must be formatted as <key>=<value>
OUTPUTS
---------- EXAMPLE 1 ----------
Clear-DaterpillarSchema SQLite 'C:/app/db.sqlite'
This will remove all table from the schema.
RELATED LINKS
https://github.com/Ackara/Daterpillar
https://flywaydb.org/documentation/commandline/clean