Column Defaults ?

Article View: borland.public.delphi.database

Article #212

Back to borland.public.delphi.database Previous Next

#212

From: IElite
Date: Fri, 23 Dec 2005 01:00

12 lines
1374 bytes

I need the SQL statement to get the default value of a column (Field)
in a Interbase, Oracle, & DB2 table

something like

SELECT     COLUMN_DEFAULT FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'your table name'


is this possible  in all SQL databases?

Is there an alternative way?

Technical Details

Message-ID: <1135299606.225792.301330@f14g2000cwb.googlegroups.com>

Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!f14g2000cwb.googlegroups.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 115d96,1482fff9b8adb5de,start
X-Google-Attributes: gid115d96,public
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!f14g2000cwb.googlegroups.com!not-for-mail
From: "IElite" <holmesshane@charter.net>
Newsgroups: borland.public.delphi.database
Subject: Column Defaults ?
Date: 22 Dec 2005 17:00:06 -0800
Organization: http://groups.google.com
Lines: 13
Message-ID: <1135299606.225792.301330@f14g2000cwb.googlegroups.com>
NNTP-Posting-Host: 68.113.165.180
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1135299611 5749 127.0.0.1 (23 Dec 2005 01:00:11 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 23 Dec 2005 01:00:11 +0000 (UTC)
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: f14g2000cwb.googlegroups.com; posting-host=68.113.165.180;
   posting-account=HSpOew0AAADnQ1e51bh3ikqObWNh3jMv