Modifying Existing Tables 1

[biren]

Hi,

I have a database which is on SQL Server 2000. This database has been replicated many times and now needs an update to one of the tables.

This update reqires an extra column on 1 particular table.

Is it possible to do this using SQL Script as this will be more effective (and testable) before we send it out to the DBA's.

This would be a great help.

Thanks

Biren.K

 

[jhall156]

Check out ALTER TABLE using the ADD keyword in the BOL. JHall

 

[biren]

thanks for the info JHall.....but what im trying to do is so simple and the code given in BOL is adressing all sorts of 'other' issues.

I have a column in a populated table.....

all i want to do is to keep the same datatype but change the length setting. I know that this can be done through the 'design' part but in my case it HAS to be executed via a script.

If anyone can help........



Biren "Thank God Its Friday" Kalaria

 

[clapag22]

alter table table_name alter column column_name datatype (New Length)

 

[biren]

Clapag,

you are a don!

thanks very much and i hope you enjoy the Star!

Later

Good weekend folks!