sql - 如何列出使用ATTACH打开的SQLite数据库文件中的表？(How to list the tables in a SQLite database file that was opened with ATTACH?)

Question

在SQLite 3命令行工具上使用ATTACH命令将其附加后，可以使用哪种SQL列出表以及这些表中的行在SQLite数据库文件中？

  ask by izb translate from so

Answer 1

There are a few steps to see the tables in an SQLite database:

(有一些步骤可以查看SQLite数据库中的表：)

1. List the tables in your database:

   (列出数据库中的表：)

    .tables 

2. List how the table looks:

   (列出表格的外观：)

    .schema tablename 

3. Print the entire table:

   (打印整个表：)

    SELECT * FROM tablename; 

4. List all of the available SQLite prompt commands:

   (列出所有可用的SQLite提示命令：)

    .help