Hello,

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

Is it?

I think it's not. Anywhere google takes me seems to be involving SQL
Server on that issue.

Coincidence? :-D

Karsten

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