column metadata default value

Hi everybody :-)

Is there any way to know if some column in table has default value?

Example:

CREATE TABLE customer

(First_Name char(50),

Last_Name char(50),

Address char(50) default 'Unknown', -> this dafult option i want to know

City char(50) default 'Mumbai',-> this dafult option i want to know

Country char(25),

Birth_Date date)

Tnx,

Stanislav

[431 byte] By [Stanea] at [2007-11-27 1:06:41]