| 9.2 [message #344328] |
Fri, 29 August 2008 07:17  |
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  |
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 #344338 is a reply to message #344328] |
Fri, 29 August 2008 07:45 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
