Hi all

I am trying to make DEFAULT NULL stick for a couple of SP parameters. I generally use DOMAIN but when I did it through DOMAIN (and FlameRobin) the DEFAULT would not make it to the final DDL. When I used FireBird types the DEFAULT remained.

The DEFAULT NULL in below got ignored in the final DDL
TCPROMPT CHAR250 DEFAULT NULL,
TCSEP CHAR250 DEFAULT NULL )

The DEFAULT NULL makes it through to final DDL
TCPROMPT Char(250) DEFAULT NULL,
TCSEP Char(250) DEFAULT NULL )

Please advise

Thanks and regards
Bhav