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


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

Original text of this message