At 01:39 PM 3/01/2011, Michael Ludwig wrote:

>Helen Borrie schrieb am 01.01.2011 um 08:09 (+1300):
>> >
>> >CREATE TABLE HL_Oids (
>> > OID OidKey NOT NULL CONSTRAINT PK_OIDs PRIMARY KEY
>> >);
>
>> Nevertheless, I don't consider this a tidy way to do table DDL.
>> You save a couple of keystrokes and have a messy DDL script.
>
>And I used to think I know messiness when I see some. If you don't
>mind my asking, what exactly is *messy* about the above DDL snipped?
>The constraint name is included, so it looks orderly to me.

However, most DDL scripts have many table definitions and many tables have multiple constraints.

If you have only ginger and marjoram in your spice cupboard, you can quickly find either. If you have 50 spices and 50 herbs, it is tidier and a lot easier to find a spice and a herb if the spices are on one shelf and the herbs on another. For me, tidy DDL scripts use shelves. ;-)

./hb