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