SHOW COLUMNS

Description

Returns the list of columns in a table. If the table does not exist, an exception is thrown.

Syntax

  1. SHOW COLUMNS table_identifier [ database ]

Parameters

  • table_identifier

    Specifies the table name of an existing table. The table may be optionally qualified with a database name.

    Syntax: { IN | FROM } [ database_name . ] table_name

    Note: Keywords IN and FROM are interchangeable.

  • database

    Specifies an optional database name. The table is resolved from this database when it is specified. When this parameter is specified then table name should not be qualified with a different database name.

    Syntax: { IN | FROM } database_name

    Note: Keywords IN and FROM are interchangeable.

Examples

  1. -- Create `customer` table in `salesdb` database;
  2. USE salesdb;
  3. CREATE TABLE customer(
  4.     cust_cd INT,
  5.     name VARCHAR(100),
  6.     cust_addr STRING);
  8. -- List the columns of `customer` table in current database.
  9. SHOW COLUMNS IN customer;
  10. +---------+
  11. | col_name|
  12. +---------+
  13. |  cust_cd|
  14. |     name|
  15. |cust_addr|
  16. +---------+
  18. -- List the columns of `customer` table in `salesdb` database.
  19. SHOW COLUMNS IN salesdb.customer;
  20. +---------+
  21. | col_name|
  22. +---------+
  23. |  cust_cd|
  24. |     name|
  25. |cust_addr|
  26. +---------+
  28. -- List the columns of `customer` table in `salesdb` database
  29. SHOW COLUMNS IN customer IN salesdb;
  30. +---------+
  31. | col_name|
  32. +---------+
  33. |  cust_cd|
  34. |     name|
  35. |cust_addr|
  36. +---------+