DROP a TABLE sequence

J

Janis

I have a question on drop table:

DROP TABLE tblPhoneCalls;

Does this work if there are established relationships? Or do you have to
delete the relationships first?

thanks,
 
6

'69 Camaro

Hi, Janis.
Does this work if there are established relationships?
No.

Or do you have to
delete the relationships first?
Click to expand...

Yes. Drop the foreign key constraint first. Try:

ALTER TABLE tblEmpPhones
DROP CONSTRAINT tblPhoneTypestblEmpPhones;

.. . . where tblEmpPhones is the table with the foreign key constraint and
the name of this constraint is tblPhoneTypestblEmpPhones. Then the foreign
table can be dropped without the warning message:

DROP TABLE tblPhoneTypes;

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
J

Janis

Allen
I don't have access on my computer and I did have a reason for asking but
you are right it would be easy otherwise.
 
Top