how to remove records from table?
no name
1 a
2 b
1 a
2 b
3 c
Answer Posted / krishna kum ar
delete <table_name> --------This removes only the records
not a tablespace
but
truncate <table_name>--------This removes both records as
well as tablespaces in database
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
Is sql easier than java?
what is the difference between union and union all? : Sql dba
How to run sql statements through the web interface?
what are the advantages of sql ? : Sql dba
What is full join?
What is pl sql code?
What is composite data type in pl sql?
What is clustered index in sql?
What are the advantages of indexing?
Is sql port 1433 encrypted?
what is query cache in mysql? : Sql dba
What is sql lookup?
How do you truncate?
What are the constraints available in sql?
how can you see all indexes defined for a table? : Sql dba