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); }