Added
Functions specific to Microsoft SQL Server:
ConvertTo-YMsSqlIdentifier
for converting a string to an identifer, quoted with square brackets.Get-YMsSqlExtendedProperty
for getting extended properties.Get-YMsSqlSchema
for getting metadata about a schema.Get-YMsSqlTable
for getting metadata about a table.Get-YMsSqlTableColumn
for getting metadata about a table.Initialize-YMsSqlDatabase
for creating a database.Initialize-YMsSqlSchema
for creating a schema.Invoke-YMsSqlCommand
for running queries and commands.Remove-YMsSqlTable
for dropping a table.Set-YMsSqlExtendedProperty
for adding/updating extended properties.Test-YMsSqlExtendedProperty
for testing if an extended property exists.Test-YMsSqlSchema
for testing if a schema exists.Test-YMsSqlTable
for testing if a table exists.Test-YMsSqlTableColumn
for testing if a table column exists.
Deprecated
- The
Invoke-YSqlServerCommand
function. Replaced withInvoke-YMsSqlCommand
.