I'm using MSDE
I want to delete all datas of a database(60 tables with relations, indexes, contraints...).
I can't use truncate table (Relations...),
and Delete * from Table1,2,3 ... take a long time.
Question ?
does it possible to create a SP
1 to get a script with all relations, indexes ...
2 to Remove all relations, contraints ...
3 Truncate all tables
4 and finally to restablishe all relations
There is a better way to does this work ?
Thanks
I want to delete all datas of a database(60 tables with relations, indexes, contraints...).
I can't use truncate table (Relations...),
and Delete * from Table1,2,3 ... take a long time.
Question ?
does it possible to create a SP
1 to get a script with all relations, indexes ...
2 to Remove all relations, contraints ...
3 Truncate all tables
4 and finally to restablishe all relations
There is a better way to does this work ?
Thanks