How to get all columns from a database? SQL

[h1lo]

Let’s say I had a huge database, and I didn’t know the names of any column. Is there a way to select only the columns?

[toastedpitabread]

You can do a .schema to find out the names of the columns, and well, the rest of the schema.

[h1lo]

I should have asked this yesterday… but is the correct syntax for getting the schema? I found it on StackOverflow.

SELECT * 
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME='table_name'; 

[toastedpitabread]

If you’re doing it on codecademy you can do this:

SELECT *
FROM sqlite_master;

If you have a file open in sqlite3 you can just type

.schema