public virtual void Rename(
[NotNull] string name,
[NotNull] string newName,
[CanBeNull] string type,
[NotNull] SqlBatchBuilder builder)
{
Check.NotEmpty(name, nameof(name));
Check.NotEmpty(newName, nameof(newName));
Check.NotNull(builder, nameof(builder));
builder
.Append("EXECUTE sp_rename ")
.Append(_sql.GenerateLiteral(name))
.Append(", ")
.Append(_sql.GenerateLiteral(newName));
if (type != null)
{
builder
.Append(", ")
.Append(_sql.GenerateLiteral(type));
}
}
private void GenerateRename(
[NotNull] string name,
[CanBeNull] string schema,
[NotNull] string newName,
[NotNull] string objectType,
[NotNull] SqlBatchBuilder builder)
{
builder.Append("EXECUTE sp_rename @objname = N");
if (!string.IsNullOrWhiteSpace(schema))
{
builder
.Append(_sql.GenerateLiteral(schema))
.Append(".");
}
builder
.Append(_sql.GenerateLiteral(name))
.Append(", @newname = N")
.Append(_sql.GenerateLiteral(newName))
.Append(", @objtype = N")
.Append(_sql.GenerateLiteral(objectType))
.Append(";");
}