public DropTable IncludeTable()
{
builder.DropTableHeaderText();
TableIfExists(database.Name);
builder.Begin();
builder.AppendLine(string.Format(" DROP TABLE [{0}].[{1}]", scriptTable.Schema, scriptTable.Name));
builder.AddEndGo();
builder.NewLine();
return(this);
}
public DropSp IncludeSp()
{
builder.UseDb(dbName);
builder.Go();
SpIfExists();
builder.Begin();
builder.AppendLine(string.Format("DROP PROCEDURE [{0}].[{1}]", schemaName, spName));
builder.AddEndGo();
return(this);
}
public CreateTable IncludeForeignKey()
{
builder.CreateForeignKeyConstraintHeaderText();
Table scriptTable = GetTable();
for (int i = 0; i < scriptTable.ForeignKeys.Count; i++)
{
builder.AppendLine(ScriptHelper.KeyIsNull(scriptTable.ForeignKeys[i].Name));
builder.Begin();
var foreignScripts = scriptTable.ForeignKeys[i].Script(options);
foreach (string script in foreignScripts)
{
builder.AppendLine(script);
}
builder.AddEndGo();
}
builder.NewLine();
return(this);
}
public CreateSp IncludeSp()
{
builder.AppendLine(ScriptHelper.KeyIsNull(spName, "P"));
builder.Begin();
builder.AppendLine(string.Format(" EXEC ('CREATE PROCEDURE [{0}].[{1}] AS ')", schemaName, spName));
builder.AddEndGo();
var createScripts = database.StoredProcedures[spName, schemaName].Script(options);
foreach (string script in createScripts)
{
builder.AppendLine(script);
}
builder.RemoveAnsiQuotedIdentifier();
return(this);
}