Davide Gurgone wrote:
>>Updating the data dictionary directly is a terrible terrible idea. You
>>wouldn't hex edit the file allocation table on a windows system to delete
>>
>>
>a
>
>
>>file would you?
>>
>>
>
>No I only whant to zero my database, having only void table.
>
>What can I do this???
>
>
>
To empty all tables TRUNCATE them. If you do it in the correct order ...
fact tables then
dimension tables the constraints will have no effect. This will have the
additional benefit
of resetting the high-water mark.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Wed Oct 22 2003 - 15:19:09 CDT
