Class SqlAnywhereExtensions

Extension methods for SQL Anywhere

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)

Set the unique/index constraint type to Clustered

Declaration

public static void Clustered(this ICreateConstraintOptionsSyntax expression)

Parameters

Type	Name	Description
ICreateConstraintOptionsSyntax	expression	The expression

NonClustered(ICreateConstraintOptionsSyntax)

Set the unique/index constraint type to NonClustered

Declaration

public static void NonClustered(this ICreateConstraintOptionsSyntax expression)

Parameters

Type	Name	Description
ICreateConstraintOptionsSyntax	expression	The expression

Password(ICreateSchemaOptionsSyntax, string)

Sets the schema password used during schema creation

Declaration

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

Parameters

Type	Name	Description
ICreateSchemaOptionsSyntax	expression	The schema creation expression
string	password	The password to use

Returns

Type	Description
ICreateSchemaOptionsSyntax	The next step

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