How do I change the structure of a table with data in it?

Question

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply

VaibhavChoubey@SQL Ten Centuries Points: 1033 More actions · Answer 1

Use Alter table as suggested its nota difficult thing to do just go through books online.

say for example if you want to change datatype of a column say col1 from tinyint to int it will go as :

ALTER TABLE Tab1 ALTER COLUMN col1 int NULL