how to remove records from table?
no name
1 a
2 b
1 a
2 b
3 c
Answer Posted / hannan oca
delete from tablename; will remove all records but we can
rollback these values.
truncate tablename; will remove all records but we cannot
rollback the table values if we want that values in future.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Mention what does plv msg allows you to do?
How do I view a table in sql?
What is indexing in sql and its types?
What is full form of rtm?
What is query execution plan in sql?
What is sql lookup?
What is sql prepared statement?
Explain the purpose of %type and %rowtype data types?
Explain isolation levels. : Transact sql
Is natural join same as inner join?
how can you create an empty table from an existing table? : Sql dba
What is left join in sql?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
What is the sql query to display the current date?
What are the different type of joins in sql?