New-BigIntColumn

Creates a column object representing an BigInt datatype.

Syntax

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

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

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

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

Description

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

Add-Table 'Migrations' {
    BigInt 'MigrationID'
}

ALIASES

BigInt

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 'Migrations' { BigInt 'MigrationID' }

Demonstrates how to create an optional bigint column called MigrationID.

EXAMPLE 2

Add-Table 'Migrations' { BigInt 'ID' -Identity 1 1 }

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

EXAMPLE 3

Add-Table 'Migrations' { BigInt 'MigrationID' -NotNull }

Demonstrates how to create a required bigint column called MigrationID.

EXAMPLE 4

Add-Table 'Migrations' { BigInt 'MigrationID' -Sparse }

Demonstrates how to create a sparse, optional bigint column called MigrationID.

EXAMPLE 5

Add-Table 'Migrations' { BigInt 'MigrationID' -NotNull -Default '0' }

Demonstrates how to create a required bigint column called MigrationID with a default value of 0.

EXAMPLE 6

Add-Table 'Migrations' { BigInt 'MigrationID' -NotNull -Description 'The number of items currently on hand.' }

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