Returns a single column of type UInt8. If the table or database does not exist, the column contains the value 0; if the table exists in the specified database, the column contains the value 1.
Syntax

EXISTS [TEMPORARY] [TABLE|DICTIONARY] [db.]name

Example

exists table db1.describe_example