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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Empty all tables via admin

Author  Topic 

xrum
Yak Posting Veteran

87 Posts

Posted - 2009-05-26 : 09:49:29
is there a way to empty all values in all tables via SQL Enterprise Manager?


i basically, want to load(import) fresh data in to replace the old one....

Thanks!

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-05-26 : 09:55:26
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=65341

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

xrum
Yak Posting Veteran

87 Posts

Posted - 2009-05-26 : 10:00:53
thank you, but is there a way to do this via admin, instead of sql code?
Go to Top of Page

xrum
Yak Posting Veteran

87 Posts

Posted - 2009-05-26 : 10:09:33
i believe i found it, it's under the transform option, in the import data screen.

please correct me if i'm wrong.

Thanks!
Go to Top of Page
   

- Advertisement -