What are the challenges you face when working across database platforms? Take the survey
Options

BUG: Rule IE028 raises warning when adding a PERSISTED computed column

JaccoJacco Posts: 11 Bronze 1

There is an IE028 warning ("Adding NOT NULL column without DEFAULT value") on the third statement, but not on the other two. 


CREATE TABLE dbo.Test_EI028 (t1 AS (1) PERSISTED NOT NULL);

ALTER TABLE dbo.Test_EI028

ADD t2 AS (1) NOT NULL;

ALTER TABLE dbo.Test_EI028

ADD t3 AS (1) PERSISTED NOT NULL;

Tagged:

Comments

Sign In or Register to comment.