public void AddSchemaAndTablenameParametersToCommand(IDbCommand dc, SchemaObjectName tableOrViewname)
{
if (tableOrViewname.HasSchema())
{
AddInput(dc, "dbname", tableOrViewname.Schema);
}
AddInput(dc, "tablename", tableOrViewname.Name);
}
public string GetAllColumnsSql(SchemaObjectName tableOrViewName)
{
StringBuilder query = new StringBuilder();
query
.Append("SELECT column_name, data_type, character_maximum_length as data_type_size ")
.Append("FROM information_schema.columns ")
.Append("WHERE ");
if (tableOrViewName.HasSchema())
{
query.Append("LOWER(table_schema)=?dbname AND LOWER(table_name)=?tablename ");
}
else
{
query.Append("(table_schema=database() AND LOWER(table_name)=?tablename) ");
}
query.Append("ORDER BY ordinal_position");
return(query.ToString());
}
public void AddSchemaAndTablenameParametersToCommand(IDbCommand dc, SchemaObjectName tableOrViewname)
{
if (tableOrViewname.HasSchema()) AddInput(dc, "dbname", tableOrViewname.Schema);
AddInput(dc, "tablename", tableOrViewname.Name);
}
public string GetAllColumnsSql(SchemaObjectName tableOrViewName)
{
StringBuilder query = new StringBuilder();
query
.Append("SELECT column_name, data_type, character_maximum_length as data_type_size ")
.Append("FROM information_schema.columns ")
.Append("WHERE ");
if(tableOrViewName.HasSchema())
{
query.Append("LOWER(table_schema)=?dbname AND LOWER(table_name)=?tablename ");
}
else
{
query.Append("(table_schema=database() AND LOWER(table_name)=?tablename) ");
}
query.Append("ORDER BY ordinal_position");
return query.ToString();
}
