Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

T-SQL : Field Property

Posted on 2003-12-11
1
Medium Priority
?
264 Views
Last Modified: 2006-11-17
Using T-SQL how is the property NOT NULL added to an existing table field ?
0
Comment
Question by:caracalla
1 Comment
 
LVL 70

Accepted Solution

by:
Scott Pletcher earned 400 total points
ID: 9921304
ALTER TABLE yourTableName
ALTER COLUMN columnName datatype NOT NULL


I believe you will have to change any NULL values in that column to a non-NULL value first for this to work.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question