protected override string GetQueryTableExists(TableInfo tableInfo)
{
var syntax = string.Format(CultureInfo.InvariantCulture,
@"SELECT table_schema
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME = '{0}'", tableInfo.TableName);
if (!string.IsNullOrEmpty(DatabaseName))
syntax += string.Format(" AND TABLE_SCHEMA = '{0}'", DatabaseName);
return syntax;
}
/// <summary>
/// Gets the table name and schema.
/// </summary>
/// <param name="tableName">Name of the table.</param>
/// <returns>Table name and schema.</returns>
public TableInfo GetTableInfo(string tableName)
{
var info = new TableInfo { TableName = tableName, Schema = this.DefaultSchema };
// Splite schema out if it is specified.
var match = SchemaRegex.Match(tableName);
if (match.Success)
{
info.Schema = match.Groups["Schema"].Value;
info.TableName = SchemaRegex.Replace(tableName, string.Empty);
}
return info;
}
protected override string GetQueryTableExists(TableInfo tableInfo)
{
return string.Format("SELECT * FROM rdb$relation_fields WHERE rdb$relation_name = '{0}'", tableInfo.TableName.ToUpper());
}
///// <summary>
///// Gets the default schema for a table.
///// </summary>
///// <value>
///// Default schema.
///// </value>
//public override string DefaultSchema
//{
// get { return "dbo"; }
//}
protected override string GetQueryTableExists(TableInfo tableInfo)
{
var syntax = string.Format("select object_id(schema_name() + '.' + '{0}')", tableInfo.TableName);
return syntax;
}
protected virtual string GetQueryTableExists(TableInfo tableInfo)
{
var syntax = string.Format(CultureInfo.InvariantCulture,
@"SELECT table_schema
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME = '{0}'", tableInfo.TableName.ToLower());
if (!string.IsNullOrWhiteSpace(tableInfo.Schema))
syntax += string.Format(" AND TABLE_SCHEMA = '{0}'", tableInfo.Schema);
return syntax;
}
protected override string GetQueryTableExists(TableInfo tableInfo)
{
return string.Format("SELECT * FROM USER_TABLES WHERE TABLE_NAME = '{0}'", tableInfo.TableName.ToUpper());
}
protected override string GetQueryTableExists(TableInfo tableInfo)
{
return(string.Format("SELECT NAME FROM SYSOBJECTS WHERE NAME = '{0}'", tableInfo.TableName));
}
protected override string GetQueryTableExists(TableInfo tableInfo)
{
return string.Format("SELECT NAME FROM SYSOBJECTS WHERE NAME = '{0}'", tableInfo.TableName);
}
