(i) Which command is used to view the list of tables in a database?
(i) Which command is used to view the list of tables in a database?
(ii) Give one point of difference between an equi-join and a natural join.
5 views
1 Answers
(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
5 views
Answered