Interface IQuerySchema

Gets the interface to query a database

Namespace: FluentMigrator

Assembly: FluentMigrator.Abstractions.dll

Syntax

public interface IQuerySchema

Properties

DatabaseType

Gets the database type

Declaration

[NotNull]
string DatabaseType { get; }

Property Value

Type	Description
string

DatabaseTypeAliases

Gets the database type aliases

Declaration

[NotNull]
[ItemNotNull]
IList<string> DatabaseTypeAliases { get; }

Property Value

Type	Description
IList<string>

Methods

ColumnExists(string, string, string)

Tests if a column exists

Declaration

bool ColumnExists(string schemaName, string tableName, string columnName)

Parameters

Type	Name	Description
string	schemaName	The schema name
string	tableName	The table name
string	columnName	The column name

Returns

Type	Description
bool	true when it exists

ConstraintExists(string, string, string)

Tests if a constraint exists

Declaration

bool ConstraintExists(string schemaName, string tableName, string constraintName)

Parameters

Type	Name	Description
string	schemaName	The schema name
string	tableName	The table name
string	constraintName	The constraint name

Returns

Type	Description
bool	true when it exists

DefaultValueExists(string, string, string, object)

Tests if a default value for a column exists

Declaration

bool DefaultValueExists(string schemaName, string tableName, string columnName, object defaultValue)

Parameters

Type	Name	Description
string	schemaName	The schema name
string	tableName	The table name
string	columnName	The column name
object	defaultValue	The default value

Returns

Type	Description
bool	true when it exists

IndexExists(string, string, string)

Tests if an index exists

Declaration

bool IndexExists(string schemaName, string tableName, string indexName)

Parameters

Type	Name	Description
string	schemaName	The schema name
string	tableName	The table name
string	indexName	The index name

Returns

Type	Description
bool	true when it exists

SchemaExists(string)

Tests if the schema exists

Declaration

bool SchemaExists(string schemaName)

Parameters

Type	Name	Description
string	schemaName	The schema name

Returns

Type	Description
bool	true when it exists

SequenceExists(string, string)

Tests if a sequence exists

Declaration

bool SequenceExists(string schemaName, string sequenceName)

Parameters

Type	Name	Description
string	schemaName	The schema name
string	sequenceName	The sequence name

Returns

Type	Description
bool	true when it exists

TableExists(string, string)

Tests if the table exists

Declaration

bool TableExists(string schemaName, string tableName)

Parameters

Type	Name	Description
string	schemaName	The schema name
string	tableName	The table name

Returns

Type	Description
bool	true when it exists