ALTER TABLE question

[Ruslan Zasukhin]

Hi Claudius,

Please copy paste your question to our online forum 


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information 
http://www.paradigmasoft.com

[I feel the need: the need for speed]

On 4/17/17, 7:46 PM, "Valentina on behalf of Claudius Sailer" <valentina-bounces at lists.macserve.net on behalf of claudius.sailer at me.com> wrote:

>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?