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 |
|
cmspot
Starting Member
44 Posts |
 Posted - 2007-10-18 : 02:03:48
|
| Hello again!I have Created a big database.Now that has finished i want to clean all my tables so i can use itIs there any way to truncate all the tables of a databaseWithout to use the order of parents - children?I mean something like to disable all Foreign keys so you don't get the false message or something like sp_Something which cleans all tables?I sell my mother in law.Is anybody interested? |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-18 : 02:10:39
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=65341 |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-18 : 02:11:04
|
| I used the SEARCH link above to find that. Perhaps you could try it? |
|
|
|
cmspot
Starting Member
44 Posts |
Posted - 2007-10-18 : 02:19:04
|
quote:
Originally posted by Kristen
I used the SEARCH link above to find that. Perhaps you could try it?
Thank you!Maybe you are right!I did not know the "search" choice.I thought it was an interner search.....Thank you anyway....You are great....I sell my mother in law.Is anybody interested? |
|
|
|
|
|
|
Truncate all tables