Re: Drop and re-create table.

I believe you can kill children ( in data terms of course) but you cannot kill their parents.. So you should be able to drop any table that does not have a primary key that is referenced by a foreign key in some existing table..

"Peter Shvets" <pshvets_at_powermarket.com> wrote:

>Hello, everybody on the group.
>I'd like to ask couple of questions.
>I have an existing table let's say TBL1 with some foreign keys pointing to
>other tables.
>I want to drop the TBL1 and re-create it with some new columns, existing and
>some new constraints(foreign keys).
>Can I do so without violating anything? I have data in some referenced
>tables.
>What happens to my primary keys?
>May be the questions are not clear, I am not sure what I am doing is
>correct.
>
>Thanks in advance.
>Peter.
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World!  Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Thu Aug 30 2001 - 13:49:56 CDT