Question Generate alter script for existing table in sql server 2000

[prasad kulkarni]

Hi,

I want to generate alter script for Existing table in Sql Server 2000
and existing record not delete .
If new column add to table ,Then existing record and column as it is, only
New column add to table, please give me step to Generate Alter Script in
sql server 2000

if any one know, please reply me soon.

 

[Hack]

ALTER TABLE

 

[prasad kulkarni]

Add or Alter column in table in sql server 2000

Hi,

how to add or alter column to table .
if column not exist add it or if column exist alter it .
what is script for it.

if any one know , please reply me soon

 

[Hack]

A very simple exercise done from Query Analyser.

ALTER TABLE