Re: Designer/2000 : Column Default USER is interpreted as 'USER'
From: Gerard H. Pille <ghp_at_santens.be>
Date: 1997/10/08
Message-ID: <01bcd3cc$b7ad2c60$7b1340c0_at_pcghp.santens.be>#1/1
Date: 1997/10/08
Message-ID: <01bcd3cc$b7ad2c60$7b1340c0_at_pcghp.santens.be>#1/1
jjfjf
-- ------------ Kind reGards \ / | X | / \ x Gerard Manish Shah <manish.shah_at_worldnet.att.net> schreef in artikel <61e63h$fkk_at_bgtnsc02.worldnet.att.net>...Received on Wed Oct 08 1997 - 00:00:00 CEST
> Hi,
>
> I am using Designer/200 Rel 1.3.2 for Win NT 4.0.
> I am facing following problem
> 1) Table Definition Related :
> Creating a table A in designer/2000 RON. Table A contains a column C with
> default value USER. Generate script shows,
> CREATE TABLE A
> ( .............
> ..............
> C VARCHAR2(30) 'USER'
> ...................
> ) ;
> This means every time I ommit the value of column C, it inserts string
> 'USER' in it. My requirement that it should generate the script like,
> CREATE TABLE A
> ( .............
> ..............
> C VARCHAR2(30) USER
> ...................
> ) ;
> (No quotes for string USER )
>
> Does anyone know ????????
>
> Thanx in advance.
>
> Cheers,
>
> Manish Shah
>