Re: SQL for retrieving default value of a table
From: Matt Foster <matt.foster_at_ed.ac.uk>
Date: 2000/02/15
Message-ID: <38A99260.28501A89_at_ed.ac.uk>#1/1
Date: 2000/02/15
Message-ID: <38A99260.28501A89_at_ed.ac.uk>#1/1
Harmony Wong wrote:
>
> Hi,
>
> Does anyone know the sql of this?
>
> Regards,
> Harmony
If you mean the default value for a column on the table one way is to
use
TOAD (www.toadsoft.com) and look at the scripts against a table.
E.G. A test table would have this against it's scripts
CREATE TABLE TEST (
PK NUMBER(10) DEFAULT 100,
SEARCH VARCHAR2(40))
TABLESPACE MBINW
PCTFREE 10 PCTUSED 40
INITRANS 1 MAXTRANS 255
STORAGE (
INITIAL 512K NEXT 512K PCTINCREASE 0
MINEXTENTS 1 MAXEXTENTS 505 )
NOCACHE;
This shows the default value for pk is 100
Matt Received on Tue Feb 15 2000 - 00:00:00 CET