DEFAULT in CREATE TABLE?

[Ivan Smahin]

Hello Andrew,

Friday, April 8, 2005, 11:37:54 PM, you wrote:

AS> In version 1, is it possible to indicate a DEFAULT value for a string:

AS> eg:
AS> CREATE TABLE questions (
AS> ...
AS> qType String(50,'ASCII') NOT NULL DEFAULT 'test',
AS> ...
AS> ...
AS> );

You can try this way:

CREATE TABLE questions (
...
qType String(50) DEFAULT 'test' NOT NULL,
...
...
);

And put this issue to the mantis please.

-- 
Best regards,
 Ivan                            mailto:IvanSmahin at public.kherson.ua