New-SmallIntColumn

Creates a column object representing an SmallInt datatype.

Syntax

New-SmallIntColumn [-Name] <String> [-Sparse] [-Default <String>] [-Description <String>] [<CommonParameters>]

New-SmallIntColumn [-Name] <String> -Identity [-Seed] <Int32> [-Increment] <Int32> [-NotForReplication] [-Default <String>] [-Description <String>] [<CommonParameters>]

New-SmallIntColumn [-Name] <String> -Identity [-NotForReplication] [-Default <String>] [-Description <String>] [<CommonParameters>]

New-SmallIntColumn [-Name] <String> -NotNull [-Default <String>] [-Description <String>] [<CommonParameters>]

Description

Use this function in the Column script block for Add-Table:

Add-Table 'Items' {
    SmallInt 'Quantity'
}

ALIASES

SmallInt

Parameters

Name	Type	Description	Required?	Pipeline Input	Default Value
Name	String	The column's name.	true	false
Identity	SwitchParameter	The column should be an identity.	true	false	False
Seed	Int32	The starting value for the identity.	true	false	0
Increment	Int32	The increment between auto-generated identity values.	true	false	0
NotForReplication	SwitchParameter	Stops the identity from being replicated.	false	false	False
NotNull	SwitchParameter	Don't allow `NULL` values in this column.	true	false	False
Sparse	SwitchParameter	Store nulls as Sparse.	false	false	False
Default	String	A SQL Server expression for the column's default value	false	false
Description	String	A description of the column.	false	false

EXAMPLE 1

Add-Table 'Items' { SmallInt 'Quantity' }

Demonstrates how to create an optional smallint column called Quantity.

EXAMPLE 2

Add-Table 'Items' { SmallInt 'Quantity' -Identity 1 1 }

Demonstrates how to create a required smallint column called Quantity, which is used as the table's identity. The identity values will start at 1, and increment by 1.

EXAMPLE 3

Add-Table 'Items' { SmallInt 'Quantity' -NotNull }

Demonstrates how to create a required smallint column called Quantity.

EXAMPLE 4

Add-Table 'Items' { SmallInt 'Quantity' -Sparse }

Demonstrates how to create a sparse, optional smallint column called Quantity.

EXAMPLE 5

Add-Table 'Items' { SmallInt 'Quantity' -NotNull -Default '0' }

Demonstrates how to create a required smallint column called Quantity with a default value of 0.

EXAMPLE 6

Add-Table 'Items' { SmallInt 'Quantity' -NotNull -Description 'The number of items currently on hand.' }

Demonstrates how to create a required smallint column with a description.