SQL TABLE
What is a TABLE?
A table is a collection of data organized in rows and columns.
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_ID | book_Name | book_Author |
---|---|---|
00001 | The Catcher in the Rye | J. D. Salinger |
00002 | Anna Karenina | Leo 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:
-
Display a list of data from tables using ‘join’. And many more…💨
public
schema. Furthermore, you can also create and specify tables to other specific schemas. Click here for more info.