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