Home Forums SQL Server 7,2000 T-SQL How to Generate Alter Table Script Dynamically. RE: How to Generate Alter Table Script Dynamically.

  • March 17, 2009 at 3:59 pm

    #961454

    santoooo (2/2/2009)

    hi all,

    please correct me if anything wrong with this code. and please post how we can do with the Information_Schema.columns.

    - no identites;

    - no collations;

    - "DEFAULT" is actually a constraint, probably named, this script will lose it;

    - no other constraints;

    - column name with "[" or "]" in it will cause an error (look for QIOTENAME in BOL)

    etc.

    _____________
    Code for TallyGenerator