SHOW COLUMNS syntax Issue

Question

I am trying to find Show Columns like and referring to this : sql show columns

But something wrong with Syntax:

SHOW COLUMNS  LIKE '%ACCOUNT_ID%'   IN { ACCOUNT | [ DATABASE ] "CLIENT_DB" | [ SCHEMA ] "ACCOUNTS" }

Answer 1

Try something like the statements below:

SHOW COLUMNS LIKE '%ACCOUNT_ID%' IN DATABASE CLIENT_DB;

SHOW COLUMNS LIKE  '%ACCOUNT_ID%' IN SCHEMA CLIENT_DB.ACCOUNTS;