Clearing a Table

I have entered some temporary values in a table located in an SQL database, to test a project to see if it was working. Now I want to remove the values so that later, the program I have created will be capable of using the table for it's true purpose. However, when I try to delete the values located there, I receive an error message. How can I clear the table?

you have not mentioned the error. Anyhow, the possible problems are either Permission or the table which you are deleting may have child tables which referencing this table. Check the permision first. For reference issue delete the child tables data first and then delete the master table

Madhu

|||

Most likely, you have a relationship (PK-FK) established between this table and another. (But, as Madhu suggested, it could also be a permission issue.)

Please post the entire error message so that we can better assit you.