Hahahaha yes 42 is the answer to everything

An easy one !

This is a funny QOTD.

The only one I didn't get was the 9th.

Is \, numeric ?

I have had the answer, without seeing that the trigger wasn't created. 😀

Seems logical for me

straightforward but usefull.

What is the advantage to disable indexes ?

I 've never used that.

Or I make and use an index,

or I do not make an index,

or I drop an index if...

Thanks PMA...

That is a nice script.

It is still strange that when I scripted the Indexed, it was not obvious that the primairy key was disabled.

This script does.

Thanks again

Thanks, good question. It helps me.

Hello Hany,

Yes you are right.

I was already a step forward.

I didn't look well in the Message pane.

Thanks.

Strange. It looks to me that the primairy key index isn't disabled.

I scripted all 3 keys and noticed that only at the 2 non-primairy indexescript had an extra line inserted...

I had to look very carefully.

At first sight all options were right.

But 3 had to be right ...

Thanks

I understand that your script is the most clear Tom.

The default is on the same line as the column name and the constraint has a self given name.

But that was...

When you look carefully you will know it.

I should have know that ! hahahahaha