What is the query to check if an attribute in a table existed or not?

The question is in the title is clear, I guess.

What/how is the query to check if an attribute in a table existed or n开发者_Go百科ot?

I am doing with SQLite.

Thanks in advance.

---

You can interrogate the database with PRAGMA table_info(tablename);. That will return the list of column names, their type, nullable or not, and default value.