Deleting a Table

15 pts.
Tags:
Database
I have full permissions to a DB, but I can not delete a table.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    What is the "DB"? What software? What platform? How do you know you have "full permissions" to the DB? And how do you know you can't delete a table? (How did you try? What was the result? Was there a message or code?) Is the problem that you can't delete any table or a specific table? Are others also having a problem? Is it a local or a remote DB? -- Tom
    125,585 pointsBadges:
    report
  • jinteik
    if you have full permission chances are you are able to delete the table. but like Tom mention, do give us more information
    17,985 pointsBadges:
    report
  • carlosdl
    "what qury ur using and please check the dbconnection and use the delete from table_name"  What is a 'qury' ?  Anyway, a table deletion command is not a query, and an SQL 'delete from ...'  will not delete a table on any platform.  The dependency check is a good point, though, but without more details from the OP, we have no way to know how to help him/her.
    69,920 pointsBadges:
    report
  • JohnKennedy
    415 pointsBadges:
    report
  • JohnKennedy
    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
    415 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following