Can I create tables PEOPLE and people in SQL?

Question

SQL is case insensitive, so is it possible?

Answer 1

SQL converts your table name to uppercase by default. (Some SQLs have also configuration file for that)
Nevertheless, if you need to create a table with name in lowercase use double quotes.

For, example
CREATE TABLE PEOPLE( ... );
CREATE TABLE "people"( ... );

In second case you have to use quotes for every reference to the table
e.g SELECT * FROM "people";

Answer 2

Got it! Thank you!