I like to sort tables frequently (LastName,FirstName,etc.) so that we don't always have to add an ORDER BY clause. Just lazy, I guess. This is probably not great practice but...
>From a command file I can RENAME a table to, say, TEMP (I learned the hard way >to use NOCHECK to avoid messing up forms and reports based on that table). >Then I can PROJECT <original table name> from TEMP USING * ORDER BY LastName >FirstName. Then I can DROP TABLE TEMP. NOW, how do I build a PK for ColName from the command file? ALTER TABLE is part of it BUT it wants me to declare UNIQUE VALUE for ColName before it will build the key. I know it's in the syntax somewhere but I just can't find it. I think it's more than one command. This doesn't seem all that unusual a thing to do. Could someone please help me with the syntax? Or, is there a better way to get the same result? (There usually is). I'm also interested in how to build FK and index from a command file. I realize that RELOAD or PACK would be a good thing to do after swelling up the database. Thanks, Fred Fred C. Kopp Authorized R:Base Developer 19 Teri Lane Washington, PA 15301 P 724-222-7376 F 724-222-7376 C 724-413-5534 E [EMAIL PROTECTED]
