How to check if a column in sqlite3 is autoincrement?

Question

PHP

I make a request
PRAGMA table_info(table_name)

I receive

[0]=>
  int(0)
  ["cid"]=>
  int(0)
  [1]=>
  string(2) "id"
  ["name"]=>
  string(2) "id"
  [2]=>
  string(7) "INTEGER"
  ["type"]=>
  string(7) "INTEGER"
  [3]=>
  int(0)
  ["notnull"]=>
  int(0)
  [4]=>
  NULL
  ["dflt_value"]=>
  NULL
  [5]=>
  int(0)
  ["pk"]=>
  int(0)

But how do you know if a column is auto-incrementing?

Answer 1

SELECT COUNT(*) FROM sqlite_sequence WHERE name='table_name';

you can also look at the contents of the tablesqlite_master

select tbl_name from sqlite_master where sql like '%autoincrement%'