At 19:20 +0200 on 03/11/1999, JT Kirkpatrick wrote:
> hummmmmmm! that should work! it does have a primary key associated with
> it. i bet i could create the primary key index as well, and copy that file
> into the directory too! i don't think i can create the primary key after
> the file has been created?
Well, a primary key is more or less simply a unique index, and you can
certainly create that. If you want to be pedant (so that the table
definition maybe will be dumped with "primary key" in it etc.), then I
suggest:
1) Restore the table
2) Rename it (ALTER TABLE table_name RENAME TO renamed_table_name;)
3) Create it anew with primary key
4) INSERT INTO table_name
SELECT * FROM renamed_table_name;
5) Drop the renamed table.
I think this should cover all bases.
> what's weather like in israel these days??
Basically, sunny and dry...
Herouth
--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma
************
