Re: DEFAULT constraint?

> 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.

brgds

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