Home » Misc » Which command is used to view the list of tables in a database?

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 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.

Related Posts