How to add a not null to an already existing column in SQL Server?

2018-06-27 06:45:59

This question already has an answer here:

Altering a column: null to not null 11 answers

Add the NOT NULL constraint to a column 4 answers

指定列的数据类型

ALTER TABLE [Table] ALTER COLUMN [Column] INTEGER NOT NULL;

alter table movie_archive alter column RecordID INTEGER Not null;

链接地址: http://www.djcxy.com/p/76272.html