Deleting a Table
I have full permissions to a DB, but I can not delete a table.
Software/Hardware used:
Software/Hardware used:
ASKED:
November 13, 2012 10:47 PM
UPDATED:
November 14, 2012 1:21 PM
Answer Wiki:
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.
All Answer Wiki Contributors:
JohnKennedy 
405 pts. ,
jezz341 195 pts. ,
1213456123 25 pts. ,
Michael Tidmarsh 14,015 pts. ,
dshafer 15 pts.
405 pts. ,
jezz341 195 pts. ,
1213456123 25 pts. ,
Michael Tidmarsh 14,015 pts. ,
dshafer 15 pts. To see all answers submitted to the Answer Wiki: View Answer History.
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
if you have full permission chances are you are able to delete the table. but like Tom mention, do give us more information
“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.
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