I agree with Tom what kind of database are you using?
how sure are you have the permission?or maybe you input different command to drop the table. still depends on what kind of db you are using :)
All that all the members have said are true.
1. You can't delete a table that is related to another table because records from that table(table to be deleted) contains the same records that also exist in the other table(s) otherwise inconsistency results....
2. If you would like to redesign your Database, of which I think might be case as to why you want to delete that table, then you must delete THE RELATIONSHIPS first before you proceed with your deletion.
3. You are obliged to specify what Database tool are you using....Software...and the relevant details that might enable the community understand the GRAVITY OF YOUR PROBLEMS.
Last Wiki Answer Submitted: November 16, 2012 10:56 am by JohnKennedy405 pts.