how to remove records from table?
no name
1 a
2 b
1 a
2 b
3 c
Answer Posted / rupesh
Mr. Krishna Kumar
With truncate rows will delete as well as tablespace not.
instead of tablespace you have to use physical memory space.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a trigger word?
how to dump a table to a file with 'mysqldump'? : Sql dba
What is Difference Between Unique and Primary Key Constraints?
What is the order of sql select?
Does a user_objects view have an entry for a trigger?
What are the different type of joins in sql?
What is the difference between sum and count in sql?
what is the use of set statement in tsql? : Transact sql
What is the difference between alter trigger and drop trigger statements?
How does sql profiler work?
What is trigger types in sql?
What is partition in sql query?
Is join and inner join the same?
Why do we need sharding?
what is a database? : Sql dba