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

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.