ALTER TABLE question

[Claudius Sailer]

Hello,

I have an easy question but I canÄt solve the problem.

I added a new filed in a table

ALTER TABLE EventName ADD EventArt VarChar(504)

UPDATE EventName set EventArt ='Maze‘

works also fine.



then I tried to change it to INDEXED and NOT NULL.

ALTER TABLE EventName MODIFY EventArt NOT NULL INDEXED

but this doesn’t work. What can I do that it works?


thanks for helo


Claudius