public static string FormatAlter(string ObjectType, string body, ISchemaBase item, Boolean quitSchemaBinding)
        {
            string prevText = null;
            try
            {
                prevText = (string)body.Clone();
                SearchItem sitem = FindCreate(ObjectType, item, prevText);
                Regex regAlter = new Regex("CREATE");

                if (!quitSchemaBinding)
                    return regAlter.Replace(sitem.Body, "ALTER", 1, sitem.FindPosition);
                    //return prevText.Substring(0, iFind) + "ALTER " + sitem.ObjectType + " " + prevText.Substring(iFind + sitem.ObjectType.Length + 7, prevText.Length - (iFind + sitem.ObjectType.Length + 7)).TrimStart();
                else
                {
                    string text = regAlter.Replace(sitem.Body, "ALTER", 1, sitem.FindPosition);
                    Regex regex = new Regex("WITH SCHEMABINDING", RegexOptions.IgnoreCase);
                    return regex.Replace(text, "");
                }
                //return "";
            }
            catch
            {
                return prevText;
            }
        }

 public CLRFunction(ISchemaBase parent)
     : base(parent, Enums.ObjectType.CLRFunction, Enums.ScripActionType.AddFunction, Enums.ScripActionType.DropFunction)
 {
     parameters = new List<Parameter>();
     returnType = new Parameter();
     isAggrFunc = false;
 }

 public override ISchemaBase Clone(ISchemaBase parent)
 {
     Index index = new Index(parent)
                       {
                           AllowPageLocks = this.AllowPageLocks,
                           AllowRowLocks = this.AllowRowLocks,
                           Columns = this.Columns.Clone(),
                           FillFactor = this.FillFactor,
                           FileGroup = this.FileGroup,
                           Id = this.Id,
                           IgnoreDupKey = this.IgnoreDupKey,
                           IsAutoStatistics = this.IsAutoStatistics,
                           IsDisabled = this.IsDisabled,
                           IsPadded = this.IsPadded,
                           IsPrimaryKey = this.IsPrimaryKey,
                           IsUniqueKey = this.IsUniqueKey,
                           Name = this.Name,
                           SortInTempDb = this.SortInTempDb,
                           Status = this.Status,
                           Type = this.Type,
                           Owner = this.Owner,
                           FilterDefintion = this.FilterDefintion
                       };
     ExtendedProperties.ForEach(item => index.ExtendedProperties.Add(item));
     return index;
 }

 public AssemblyFile(ISchemaBase parent, AssemblyFile assemblyFile, Enums.ObjectStatusType status)
     : base(parent, Enums.ObjectType.AssemblyFile)
 {
     this.Name = assemblyFile.Name;
     this.content = assemblyFile.content;
     this.Status = status;
 }

 public View(ISchemaBase parent)
     : base(parent, Enums.ObjectType.View, Enums.ScripActionType.AddView, Enums.ScripActionType.DropView)
 {
     Indexes = new SchemaList<Index, View>(this, ((Database)parent).AllObjects);
     Triggers = new SchemaList<Trigger, View>(this, ((Database)parent).AllObjects);
     CLRTriggers = new SchemaList<CLRTrigger, View>(this, ((Database)parent).AllObjects);
 }

 public UserDataType(ISchemaBase parent)
     : base(parent, Enums.ObjectType.UserDataType)
 {
     Default = new Default(this);
     Rule = new Rule(this);
     Dependencys = new List<ObjectDependency>();
 }

 /// <summary>
 /// Clona el objeto en una nueva instancia.
 /// </summary>
 public override ISchemaBase Clone(ISchemaBase parent)
 {
     TableOption option = new TableOption(parent);
     option.Name = this.Name;
     option.Status = this.Status;
     option.Value = this.Value;
     return option;
 }

 public new Default Clone(ISchemaBase parent)
 {
     Default item = new Default(parent);
     item.Id = this.Id;
     item.Name = this.Name;
     item.Owner = this.Owner;
     item.Value = this.Value;
     return item;
 }

 public override ISchemaBase Clone(ISchemaBase parent)
 {
     Synonym item = new Synonym(parent);
     item.Id = this.Id;
     item.Name = this.Name;
     item.Owner = this.Owner;
     item.Value = this.Value;
     item.Guid = this.Guid;
     return item;
 }

 public Rule Clone(ISchemaBase parent)
 {
     Rule item = new Rule(parent);
     item.Id = this.Id;
     item.Name = this.Name;
     item.Owner = this.Owner;
     item.Text = this.Text;
     item.Guid = this.Guid;
     return item;
 }

 public SqlAction(ISchemaBase item)
 {
     if ((item.ObjectType == Enums.ObjectType.Column) || (item.ObjectType == Enums.ObjectType.Index) || (item.ObjectType == Enums.ObjectType.Constraint))
         this.name = item.Name;
     else
         this.name = item.FullName;
     this.action = item.Status;
     this.type = item.ObjectType;
     childs = new List<SqlAction>();
 }

 /// <summary>
 /// Clona el objeto en una nueva instancia.
 /// </summary>
 public override ISchemaBase Clone(ISchemaBase parent)
 {
     StoreProcedure item = new StoreProcedure(parent);
     item.Text = this.Text;
     item.Status = this.Status;
     item.Name = this.Name;
     item.Id = this.Id;
     item.Owner = this.Owner;
     item.Guid = this.Guid;
     return item;
 }

 public override ISchemaBase Clone(ISchemaBase parent)
 {
     FileGroup file = new FileGroup(parent);
     file.IsDefaultFileGroup = this.IsDefaultFileGroup;
     file.IsReadOnly = this.IsReadOnly;
     file.Name = this.Name;
     file.Id = this.Id;
     file.Files = this.Files.Clone(file);
     file.Guid = this.Guid;
     file.IsFileStream = this.IsFileStream;
     return file;
 }

 /// <summary>
 /// Clona el objeto en una nueva instancia.
 /// </summary>
 public new XMLSchema Clone(ISchemaBase parent)
 {
     XMLSchema item = new XMLSchema(parent);
     item.Text = this.Text;
     item.Status = this.Status;
     item.Name = this.Name;
     item.Id = this.Id;
     item.Owner = this.Owner;
     item.Guid = this.Guid;
     item.Dependencys = this.Dependencys;
     return item;
 }

 public new PartitionFunction Clone(ISchemaBase parent)
 {
     PartitionFunction item = new PartitionFunction(parent);
     item.Id = this.Id;
     item.IsBoundaryRight = this.IsBoundaryRight;
     item.Name = this.Name;
     item.Precision = this.Precision;
     item.Scale = this.Scale;
     item.Size = this.Size;
     item.Type = this.Type;
     this.Values.ForEach(value => { item.Values.Add(value); });
     return item;
 }

 public override ISchemaBase Clone(ISchemaBase parent)
 {
     FileGroupFile file = new FileGroupFile(parent);
     file.Growth = this.Growth;
     file.Id = this.Id;
     file.IsPercentGrowth = this.IsPercentGrowth;
     file.IsSparse = this.IsSparse;
     file.MaxSize = this.MaxSize;
     file.Name = this.Name;
     file.PhysicalName = this.PhysicalName;
     file.Size = this.Size;
     file.Type = this.Type;
     return file;
 }

 /// <summary>
 /// Clona el objeto en una nueva instancia.
 /// </summary>
 public override ISchemaBase Clone(ISchemaBase parent)
 {
     Function item = new Function(parent);
     item.Text = this.Text;
     item.Status = this.Status;
     item.Name = this.Name;
     item.Id = this.Id;
     item.Owner = this.Owner;
     item.Guid = this.Guid;
     item.IsSchemaBinding = this.IsSchemaBinding;
     this.DependenciesIn.ForEach(dep => item.DependenciesIn.Add(dep));
     this.DependenciesOut.ForEach(dep => item.DependenciesOut.Add(dep));
     return item;
 }

 /// <summary>
 /// Clona el objeto en una nueva instancia.
 /// </summary>
 public override ISchemaBase Clone(ISchemaBase parent)
 {
     View item = new View(parent);
     item.Text = this.Text;
     item.Status = this.Status;
     item.Name = this.Name;
     item.Id = this.Id;
     item.Owner = this.Owner;
     item.IsSchemaBinding = this.IsSchemaBinding;
     item.DependenciesIn  = this.DependenciesIn;
     item.DependenciesOut = this.DependenciesOut;
     item.Indexes = this.Indexes.Clone(item);
     item.Triggers = this.Triggers.Clone(item);
     return item;
 }

 /// <summary>
 /// Clona el objeto en una nueva instancia.
 /// </summary>
 public override ISchemaBase Clone(ISchemaBase parent)
 {
     Trigger trigger = new Trigger(parent);
     trigger.Text = this.Text;
     trigger.Status = this.Status;
     trigger.Name = this.Name;
     trigger.IsDisabled = this.IsDisabled;
     trigger.InsteadOf = this.InsteadOf;
     trigger.NotForReplication = this.NotForReplication;
     trigger.Owner = this.Owner;
     trigger.Id = this.Id;
     trigger.IsDDLTrigger = this.IsDDLTrigger;
     trigger.Guid = this.Guid;
     return trigger;
 }

 public Code(ISchemaBase parent, Enums.ObjectType type, Enums.ScripActionType addAction, Enums.ScripActionType dropAction)
     : base(parent, type)
 {
     dependenciesIn = new List<String>();
     dependenciesOut = new List<String>();
     typeName = GetObjectTypeName(ObjectType);
     /*Por el momento, solo los Assemblys manejan deep de dependencias*/
     if (this.ObjectType == Enums.ObjectType.Assembly)
     {
         deepMax = 501;
         deepMin = 500;
     }
     this.addAction = addAction;
     this.dropAction = dropAction;
 }