Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-04-20 : 09:57:36
|
| Faisal writes "hello,dears, i want to delete a value which is using in another table. but when i delete it an error occur.let suppose that,there is a table "tbl_TeamMembers" and another table "tbl_Role"and now i am using a record from "tbl_Role" the primary key of "tbl_Role" which is "Role_ID" in to the "tbl_TeamMembers" as a foreign key. if there is a record which is also in the "tbl_TeamMembers" and i want to delete it from "tbl_Role" it does not allow me to delete a record.please help me.byefaisal dar" |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-04-20 : 11:29:59
|
| You need to delete the child table first, then the parent.Is that what you're asking?Brett8-) |
 |
|
|
|
|
|
how to delete a record which is using in another table