SQLite3: Command to view created table in SQLite shell?

Question

I'm new to SQLite3 and would like to verify that the table and columns I have created were actually created. Is there a shell command that will display the table and columns? I tried Googling it but all I get is information on creating views. The .help doesn't appear to have anything that would help me. I would appreciate any information on this matter. Thank you in advance.

Not that I know of. You can use this: addons.mozilla.org/en-US/firefox/addon/sqlite-manager — Robert Harvey
– Robert Harvey, Commented Jun 27, 2012 at 15:26

Stefan · Accepted Answer · 2012-06-27 15:27:34Z

2

pragma table_info(YourTable);

lists all the columns of your table

To see the create table statement:

select * from sqlite_master where type = 'table' and tbl_name = 'YourTable';

answered Jun 27, 2012 at 15:27

Stefan

1,1017 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Prizoff · Accepted Answer · 2012-07-25 21:17:16Z

0

From SQLite shell:

.schema <TABLE_NAME>

will show schema of TABLE_NAME. Remember not to place ';' after it.

answered Jul 25, 2012 at 21:17

Prizoff

4,5654 gold badges45 silver badges70 bronze badges

Collectives™ on Stack Overflow

SQLite3: Command to view created table in SQLite shell?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related