public override string SerializeTableExists(SQLTableExists tableExists)
{
var select = new SQLSelect();
select.Tables.Add("TABLES").SchemaName = "INFORMATION_SCHEMA";
select.Where.Add("TABLE_NAME", ComparisonOperator.EqualTo, tableExists.Name);
return SerializeSelect(select);
}
public override string SerializeTableExists(SQLTableExists tableExists)
{
var select = new SQLSelect();
select.Tables.Add("X$FILE");
select.Where.Add("Xf$name", ComparisonOperator.EqualTo, tableExists.Name);
return SerializeSelect(select);
}
/// <summary> /// Should return the SELECT statement that when executed returns a row. /// If a row is returned then the table exists. /// </summary> public abstract string SerializeTableExists(SQLTableExists tableExists);
public override string SerializeTableExists(SQLTableExists tableExists)
{
return "SHOW TABLES LIKE " + SerializeValue(tableExists.Name);
}
public override string SerializeTableExists(SQLTableExists tableExists)
{
var select = new SQLSelect();
select.Tables.Add("sqlite_master");
select.Where.Add("type", ComparisonOperator.EqualTo, "table");
select.Where.Add("name", ComparisonOperator.EqualTo, tableExists.Name);
return SerializeSelect(select);
}
