是否有与 MySQL 的 DESCRIBE [table] 等效的 SQLite?

Is there an SQLite equivalent to MySQL#39;s DESCRIBE [table]?(是否有与 MySQL 的 DESCRIBE [table] 等效的 SQLite?)

问题描述

我刚刚开始学习 SQLite.能够查看表的详细信息会很好，例如 MySQL 的 DESCRIBE [table].PRAGMA table_info [table] 不够好，因为它只有基本信息(例如，它不显示列是否属于某种类型的字段).SQLite 有办法做到这一点吗?

I'm just getting started learning SQLite. It would be nice to be able to see the details for a table, like MySQL's DESCRIBE [table]. PRAGMA table_info [table] isn't good enough, as it only has basic information (for example, it doesn't show if a column is a field of some sort or not). Does SQLite have a way to do this?

推荐答案

SQLite 命令行实用程序 有一个 .schema TABLENAME 命令可以显示创建语句.

The SQLite command line utility has a .schema TABLENAME command that shows you the create statements.

这篇关于是否有与 MySQL 的 DESCRIBE [table] 等效的 SQLite?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！