Home » RDBMS Server » Server Administration » 9.2 (delete all data)
9.2 [message #344328] Fri, 29 August 2008 07:17 Go to next message
pratik123
Messages: 41
Registered: October 2007
Location: hyderabad
Member
hi seniours i have a database of 30 gb there are three user and 1300 table
is it possible to delete all intries of only data
Re: 9.2 [message #344330 is a reply to message #344328] Fri, 29 August 2008 07:22 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Do you want to truncate all tables?
You can write a script that queries all the tables of all the schemas and truncate them.
Re: 9.2 [message #344335 is a reply to message #344330] Fri, 29 August 2008 07:35 Go to previous messageGo to next message
pratik123
Messages: 41
Registered: October 2007
Location: hyderabad
Member
no sir not table

only only data from all table
Re: 9.2 [message #344338 is a reply to message #344328] Fri, 29 August 2008 07:45 Go to previous message
varu123
Messages: 754
Registered: October 2007
Senior Member
Sir?
I am not that much old.
Anyways, truncate will remove only the data from the tables and not the table structure.
Previous Topic: Sending email notifications for user defines metrics
Next Topic: Temp growing too much
Goto Forum:
  


Current Time: Sat Dec 03 05:40:49 CST 2016

Total time taken to generate the page: 0.07700 seconds