altering a table column

Question

create  table Names (
   FirstName  varchar(40),
   LastName  varchar(40),
   FullName  AS FirstName+LastName
)

but now, in the full name i want that a space is inserted between first and last name, so i am altering the table but it gives syntax error. how to alter it.

alter table Names
alter column fullname as FirstName+' '+LastName

JohnOpincar · Accepted Answer · 2011-03-23 12:53:24Z

4

You can do this instead:

alter table Names drop column fullname 
alter table Names add fullname as FirstName+' '+LastName

answered Mar 23, 2011 at 12:53

JohnOpincar

5,8333 gold badges39 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Martin Smith Over a year ago

+1 Looking at ALTER TABLE .. ALTER COLUMN in BOL I think this is the only way. <computed_column_definition> only appears under ADD

gbn · Accepted Answer · 2011-03-23 12:56:12Z

2

You can not ALTER computed columns. You can drop and recreate

answered Mar 23, 2011 at 12:56

gbn

434k84 gold badges602 silver badges690 bronze badges

Collectives™ on Stack Overflow

altering a table column

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related