What is a TABLE?

A table is a collection of data organized in rows and columns.

A table has a specified number of columns but can have any number of rows.

How does a TABLE work?

You may easily create data for real-time analysis and reporting by using the statement TABLE. It can connect datasets, filter datasets, apply SQL functions, batch together datasets (union), and more.

In tables, data is systematically arranged in a row-and-column structure like a spreadsheet. Each column represents a record field, and each row represents a detailed record.

Let’s see an example of a library table:

book_IDbook_Namebook_Author
00001The Catcher in the RyeJ. D. Salinger
00002Anna KareninaLeo Tolstoy

In the above table:

  • library” is the table’s name.

  • book_ID”, ”book_Name” and ”book_Author” are the names of columns.

  • The combination of data from multiple columns creates a row, e.g. (00002, “Anna Karenina,” and “Leo Tolstoy”).

What can we do with the TABLE?

You can perform various operations using a table. We do support some of the table operations, such as:

  1. Create a new table.

  2. Delete an existing table.

  3. Display a list of data from an existing table.

  4. Display a list of data from tables using ‘join’. And many more…💨

By default, the table will be created in the public schema. Furthermore, you can also create and specify tables to other specific schemas. Click here for more info.