What is the difference between TRUNCATE and DROP?

Drop Removes a table from the database. Table structures, indexes, privileges, constraints will also be removed.. truncate Removes all rows from a table, but the table structures and its columns, constraints, indexes remains.
  •  1
By -
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

What is Normalization?

Database normalization is a data design and organization process applied to data structures based on rules that help building relational dat...