Javatpoint Logo
Javatpoint Logo

SQL Table

Table is a collection of data, organized in terms of rows and columns. In DBMS term, table is known as relation and row as tuple.

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

Table is the simple form of data storage. A table is also considered as a convenient representation of relations.

Let's see an example of an employee table:

Employee
EMP_NAMEADDRESSSALARY
AnkitLucknow15000
RamanAllahabad18000
MikeNew York20000

In the above table, "Employee" is the table name, "EMP_NAME", "ADDRESS" and "SALARY" are the column names. The combination of data of multiple columns forms a row e.g. "Ankit", "Lucknow" and 15000 are the data of one row.


Topics of SQL TABLE Statement

Next TopicSQL TABLE Variable




Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


B.Tech / MCA