Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 289
  • Last Modified:

How to Drop a NOT NULL constraint in SQL Server

I'm trying to drop a NOT NULL constraint off the S_TIME column. What am I doing wrong? Am I misreading syntax diagrams in my documentation?

alter table worktime alter column s_time NULL;

Thanks.
0
DataDesignIT
Asked:
DataDesignIT
1 Solution
 
nito8300Commented:
ALTER TABLE WORKTIME ALTER COLUMN S_TIME DATETIME NULL
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now