How to rename or alter column name of the existing Table?

Can any tell me How to rename or alter a column structure of the existing Table..

Re: How to rename or alter column name of the existing Table?

hi,

use ALTER Query to change the Column name in TABLE.

for ex:

ALTER TABLE table_name ALTER COLUMN column_name datatype.

also refer below links,

http://wwww.w3schools.com/sql/sql_alter.asp

http://www.techonthenet.com/sql/tables/alter_table.php

Thanks&Regards,

Arunabathan.G

Re: How to rename or alter column name of the existing Table?

sp_RENAME 'TableName.[OldColName]' , '[NewColName]', 'COLUMN'

Re: How to rename or alter column name of the existing Table?

use this to rename column of table

SP_RENAME 'TableName.ColumnName', 'NewColumnName', 'Column'

replace TableName, ColumnName and NewColumName with proper values

http://msdn.microsoft.com/en-us/library/ms188351.aspx

to change column data type, or making it not null etc, u can use alter table syntx like this

<div>ALTER TABLE TableName
ALTER COLUMN column_name varchar(MAX)</div> <div> </div> <div>see complete list of alter table syntax</div> <div>http://www.w3schools.com/sql/sql_alter.asp</div>

hope this helps...

Re: How to rename or alter column name of the existing Table?

Thank you aruna....I wanna set identity property to this column .

is this ok?

ALTER TABLE table_name

ALTER COLUMN column_name datatype identity(1,1)

But this is not working

Re: How to rename or alter column name of the existing Table?

you can easily add new column in table as identity

alter table TableName

Add ColumnName int identity(1,1)

but, to alter exisiting column and making it as identity is not straightforward... since, u might have some data in existing column which does not follow identity....

this article explains the details

http://blog.sqlauthority.com/2009/05/03/sql-server-add-or-remove-identity-property-on-column/

hope this helps...

Re: How to rename or alter column name of the existing Table?

hi,

please refer below links,

http://blog.sqlauthority.com/2009/05/03/sql-server-add-or-remove-identity-property-on-column/

http://stackoverflow.com/questions/1049210/adding-an-identity-to-an-existing-column

Thanks&Regards,

Arunabathan.G