Attribute Order

[Bruce Cartwright]

I'm a bit anal and prefer my DB tables organized somewhat the same way.  What I like to do is put my primary key and forign keys top on the list. That way I don't have to search through the table to see/find if the forign key is there.  Sometimes while creating a table its not apparent if a forign key is necessary until you start developing the relationships.  I have yet to find a way to change the attribute order.  The only work around I can think of is to just include 2 or 3 dummy forign keys when I create the new table and edit them later if I need them and delete what isn't necessary later.

Does anyone know of a more direct way to change the order?  Some apps let you drag the attribute up or down the table or provide an up or down arrow method.  My world doesn't end if I can't do it but it sure would be nice...

Thanks for any help offered,

Bruce

[Stelvio Gori]

Hi,

maybe a little late, here's the answer anyway. You can drag attributes in the desired order using the tree on the right of the screen,

best

SG