How to get table column names in SQLite

Question

SQL

In MySQL, I used SHOW COLUMNS to get detailed information about the columns of a table.

I need to get a list of column names in SQLite. SHOW COLUMNS is not a command in SQLite unfortunately. How can this be done in SQLite?

Answer 1

pragma table_info(table);

Answer 2

Everything is fine, what you need) Thank you!
Russian documentation on SQLite or a book in Russian (a reference book is better) can you tell me more?