changing table's fields?

[baran121]

Hi,
I want to learn can i change a table's fields with code.
thanks.

 

[SQLDenis]

Lookup ALTER TABLE in BOL



Syntax
ALTER TABLE table
{ [ [red]ALTER COLUMN[/red] column_name
{ new_data_type [ ( precision [ , scale ] ) ]
......
.....
...
..
.



Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[baran121]

thank you very much

 

[baran121]

i looked to SQL Help for ALTER TABLE,
but i couldnt find which i want to do.
i want to change not only column's type,but olso column's name.i found a code on net,but it didnt work.there is code:

ALTER TABLE [ ONLY ] name [ * ]
RENAME [ COLUMN ] column TO new_column

please help me.