Class SqlAnywhereExtensions

Inheritance

object

SqlAnywhereExtensions

Inherited Members

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Namespace: FluentMigrator.SqlAnywhere

Assembly: FluentMigrator.Extensions.SqlAnywhere.dll

Syntax

public static class SqlAnywhereExtensions

Fields

ConstraintType

Declaration

public const string ConstraintType = "SqlAnywhereConstraintType"

Field Value

Type	Description
string

SchemaPassword

Declaration

public const string SchemaPassword = "SqlAnywhereSchemaPassword"

Field Value

Type	Description
string

WithNullsDistinct

Declaration

public const string WithNullsDistinct = "SqlAnywhereNullsDistinct"

Field Value

Type	Description
string

Methods

Clustered(ICreateConstraintOptionsSyntax)

Declaration

public static void Clustered(this ICreateConstraintOptionsSyntax expression)

Parameters

Type	Name	Description
ICreateConstraintOptionsSyntax	expression

NonClustered(ICreateConstraintOptionsSyntax)

Declaration

public static void NonClustered(this ICreateConstraintOptionsSyntax expression)

Parameters

Type	Name	Description
ICreateConstraintOptionsSyntax	expression

Password(ICreateSchemaOptionsSyntax, string)

Declaration

public static ICreateSchemaOptionsSyntax Password(this ICreateSchemaOptionsSyntax expression, string password)

Parameters

Type	Name	Description
ICreateSchemaOptionsSyntax	expression
string	password

Returns

Type	Description
ICreateSchemaOptionsSyntax

UniqueNullsDistinct(ICreateIndexOptionsSyntax, bool)

Index should have unique values. Only one row with null value should be accepted (default for most known database engines).

Declaration

public static ICreateIndexOnColumnSyntax UniqueNullsDistinct(this ICreateIndexOptionsSyntax expression, bool nullsAreDistinct = true)

Parameters

Type	Name	Description
ICreateIndexOptionsSyntax	expression	The expression to set this option for
bool	nullsAreDistinct	true when nulls should be distinct

Returns

Type	Description
ICreateIndexOnColumnSyntax	The expression

UniqueNullsNotDistinct(ICreateIndexOptionsSyntax)

Index should have unique values, but multiple rows with null values should be accepted.

Declaration

public static ICreateIndexOnColumnSyntax UniqueNullsNotDistinct(this ICreateIndexOptionsSyntax expression)

Parameters

Type	Name	Description
ICreateIndexOptionsSyntax	expression	The expression to set this option for

Returns

Type	Description
ICreateIndexOnColumnSyntax	The expression