Alter Table Question

  • Thread starter Thread starter Darren
  • Start date Start date
D

Darren

The following will change an existing field to required...

ALTER TABLE [MyTable] ALTER COLUMN [MyColumn] Char(50) NOT NULL

But I cannot seem to find a way to do the reverse.

Any help would be appreciated.
 
Darren said:
The following will change an existing field to required...

ALTER TABLE [MyTable] ALTER COLUMN [MyColumn] Char(50) NOT NULL

But I cannot seem to find a way to do the reverse.

Any help would be appreciated.
Click to expand...

ALTER TABLE [MyTable] ALTER COLUMN [MyColumn] Char(50) NULL
 
I have tried this, but it has no affect.


MGFoster said:
Darren said:
The following will change an existing field to required...

ALTER TABLE [MyTable] ALTER COLUMN [MyColumn] Char(50) NOT NULL

But I cannot seem to find a way to do the reverse.

Any help would be appreciated.
Click to expand...

ALTER TABLE [MyTable] ALTER COLUMN [MyColumn] Char(50) NULL
Click to expand...
 
Back
Top