Site Loading

Change Sql Column Type

I have had to change the column type within Sql every now and again or make a column NULL or not NULL.  You can do it in a query with the following:

ALTER TABLE Table_Name ALTER COLUMN Column_Name DataType
Close