SQL 2008 express can't edit a table columns????

[DougP]

when I try to change a columns data type in the SSMS it says I have to drop and recreate the table?
Whats up with that?
also it won't see any new tables I add they show up with red squiggly lines? I have to completely shut down SSMS?

you get a couple of new features but lose something simple in the process?

Sometime's I wonder why I stay in IT, and don't just sweep floors? Oh I know why, the cost of everything is going up 3 fold annually.

DougP
< I Built one

http://www.robots2000.com

 

[gmmastros]

Instead of relying on the GUI for everything, now may be a good opportunity to more SQL.

for example:

Alter Table Employee Alter Column fname varchar(30)

You may not always be able to do this, like changing a varchar column to a number. There may be invalid data to deal with. But... learning how to do this in code may be the way to go.



-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[DougP]

Speaking of that what goes in the bit field now?
I thought you used to type in a 1 or 0, True False, Yes No,
????
it don't want any of that now either?


DougP
< I Built one

http://www.robots2000.com