SHOW-CATALOG-RECYCLE-BIN

Name

SHOW CATALOG RECYCLE BIN

Description

This statement is used to display the dropped meta informations that can be recovered

grammar:

  1. SHOW CATALOG RECYCLE BIN [ WHERE NAME [ = "name" | LIKE "name_matcher"] ]

grammar:

  1. The meaning of each column is as follows:
  2.         Type：                type of meta information:Database、Table、Partition
  3.         Name：                name of meta information
  4.         DbId：                id of database
  5.         TableId：             id of table
  6.         PartitionId：         id of partition
  7.         DropTime：            drop time of meta information

Example

  1. Display all meta informations that can be recovered

    1.  SHOW CATALOG RECYCLE BIN;

  2. Display meta informations with name ‘test’

    1.  SHOW CATALOG RECYCLE BIN WHERE NAME = 'test';

Keywords

  1. SHOW, CATALOG RECYCLE BIN

Best Practice