Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs
49.6kGet Started

EXISTS

View as MarkdownEdit this pageReport an issueSet up docs MCP
EXISTS [TEMPORARY] [TABLE|DICTIONARY|DATABASE] [db.]name [INTO OUTFILE filename] [FORMAT format]

Returns a single UInt8-type column, which contains the single value 0 if the table or database does not exist, or 1 if the table exists in the specified database.

Related: SHOW, DESCRIBE TABLE, CREATE

Navigation