SQL server 2005 query not running

Posted by Aayushi on Stack Overflow See other posts from Stack Overflow or by Aayushi
Published on 2011-01-07T13:45:55Z Indexed on 2011/01/07 13:54 UTC
Read the original article Hit count: 169

Filed under:
|

Hi,

Before posting this question, I have tried so many things but that was not helpful for me. I want to rename the column of table at sql server 2005, following query I have run at sql server2005:

1) ALTER TABLE Details RENAME COLUMN AccountID TO UID; but it gives me the error: Incorrect syntax near the keyword 'COLUMN'.

2)I have added one new column in the table by query: ALTER TABLE Details ADD BID uniqueidentifier; and then I want to set the coulmn property to not null . How can i do that?

Thanks in advance AS

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server-2005