private void BuildAsqlCreateFooter(AsqlBuilder ab)
{
ab.WriteLine(")");
ab.DecIndent();
ab.SlashLine("tabspace = :oldtabloc");
ab.DecIndent();
ab.SlashLine("end if");
}
private void BuildAsqlCreateHeader(AsqlBuilder ab, string tableName)
{
ab.SlashLine("on error exit");
ab.SlashLine("define oldtabloc ident(50)");
ab.IndentWrite("if not exists ");
ab.SlashLine(tableName);
ab.IncIndent();
ab.SlashLine("begin sqlserver");
ab.IncIndent();
ab.IndentWriteLine("select distinct s.groupname into :oldtabloc");
ab.IncIndent();
ab.IndentWriteLine("from sysobjects t, sysindexes i, sysfilegroups s, syscolumns c");
ab.IndentWriteLine("where t.type = 'U'");
ab.IndentWriteLine("and t.id = c.id");
ab.IndentWriteLine("and t.id = i.id");
ab.IndentWriteLine("and (i.indid=0 OR i.indid=1)");
ab.IndentWriteLine("and i.groupid = s.groupid");
ab.IndentWrite("and t.name = '");
ab.Write(tableName);
ab.WriteLine("'");
ab.DecIndent();
ab.SlashLine();
ab.DecIndent();
ab.SlashLine("end /* sqlserver */");
ab.SlashLine("begin oracle");
ab.IncIndent();
ab.IndentWriteLine("select tablespace_name into :oldtabloc");
ab.IncIndent();
ab.IndentWriteLine("from user_tables");
ab.IndentWrite("where LOWER(table_name) = '");
ab.Write(tableName);
ab.WriteLine("'");
ab.DecIndent();
ab.SlashLine();
ab.DecIndent();
ab.SlashLine("end /* oracle */");
ab.IndentWrite("create table ");
ab.Write(tableName);
ab.WriteLine(" (");
ab.IncIndent();
}