Re: DEFAULT constraint?

From: Philipp Post <>
Date: Tue, 9 Jun 2009 07:52:01 -0700 (PDT)
Message-ID: <>

> I wondered if the DEFAULT clause along with the NOT NULL, PRIMARY KEY clauses in a CREATE TABLE statement was a constraint. <

I see the SQL 92 standard referring to a DEFAULT *clause* instead of the term DEFAULT *constraint*.

Apart from that, does it make sense to specify DEFAULT for a PRIMARY KEY? Supposing it is not a compound key, it will fire at max. once and then never again.


Philipp Post Received on Tue Jun 09 2009 - 16:52:01 CEST

Original text of this message