public override string SerializeViewExists(SQLViewExists viewExists) { var select = new SQLSelect(); select.Tables.Add("X$VIEW"); select.Where.Add("Xv$Name", ComparisonOperator.EqualTo, viewExists.ViewName); return SerializeSelect(select); }
/// <summary> /// Should return the SELECT statement for determining whether a view exists. /// If a row is returned then the view exists. /// </summary> public abstract string SerializeViewExists(SQLViewExists viewExists);
public override string SerializeViewExists(SQLViewExists viewExists) { throw new NotSupportedException(); }
public override string SerializeViewExists(SQLViewExists viewExists) { var select = new SQLSelect(); select.Tables.Add("VIEWS").SchemaName = "INFORMATION_SCHEMA"; select.Where.Add("TABLE_SCHEMA", ComparisonOperator.EqualTo, "PUBLIC"); select.Where.Add("TABLE_NAME", ComparisonOperator.EqualTo, viewExists.ViewName); return SerializeSelect(select); }
public override string SerializeViewExists(SQLViewExists viewExists) { var select = new SQLSelect(); select.Tables.Add("sqlite_master"); select.Where.Add("Type", ComparisonOperator.EqualTo, "View"); select.Where.Add("Name", ComparisonOperator.EqualTo, viewExists.ViewName); return SerializeSelect(select); }