ok,

But in my scenario i want the Alter Script, to update. Coz, we are developing a tool to update the other dbs, for that purpose i want to generate the script and finally i will execute that script...

There is a possibility of generating the script from the syscolumns table right, i am trying this method... if anyone is having better solution please share..

thank you .

---

Santooo