Answer Posted / udhayakumar
delete is used to delete one or more rows from the table
where as truncate to delete all the rows without its
structure from the table
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the types of subqueries?
What are the uses of merge?
What are the commands used in sql?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
What is cursor and its types?
What is linq to sql?
What is pl sql in oracle?
What are the different sql languages?
What's the procedure?
what are local and global variables and their differences? : Sql dba
What is application trigger?
What is not null in sql?
What is loop in pl sql?
Why do we use sqlite?
Write a sql query to convert all character to uppercase after hypen.