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 |
|
MichelleMA
Starting Member
32 Posts |
 Posted - 2007-01-12 : 11:23:27
|
| Hi, Is there a way to force a truncate on a table when it is being referenced by a foreign key constraint, whithout having to delete the relation?Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-12 : 12:53:29
|
| No. Drop constraintTruncate Create constraintOrDelete from tableTara Kizer |
 |
|
|
MichelleMA
Starting Member
32 Posts |
Posted - 2007-01-12 : 13:40:44
|
| Thanks |
|
|
|
|
|
|
TRUNCATE