(i) Which command is used to view the list of tables in a database?
(ii) Give one point of difference between an equijoin and a natural join.
Answer
(i) SHOW TABLES:
(ii) Equi- join:
- The join in which columns from two tables are compared for equality.
- Duplicate columns are shown Natural Join.
- The join in which only one of the identical columns existing in both tables is present.
- No duplication of columns.