What is a Table in a Database?

A table is a collection of related data in an organized manner in the form of rows and columns. It is an organized arrangement of data and information in tabular form containing rows and columns, making it easier to understand and compare data.

Here is the pictorial representation of the table and its different components containing the data about different students that is ID, name, Age, and course.

Now let’s create the above table in SQL server management studio.

Create a Database using the below query.

CREATE DATABASE StudentsDatabase;

Create a Table named as Students.

CREATE TABLE Students (
    ID INT PRIMARY KEY,
    NAME VARCHAR(50),
    AGE INT,
    COURSE VARCHAR(50)
);

Insert the data into it.

INSERT INTO Students (ID, NAME, AGE, COURSE)
VALUES
    (1, 'MINAL', 22, 'COMPUTER SCIENCE'),
    (2, 'MRIDUL', 21, 'CIVIL'),
    (3, 'MARAM', 19, 'CHEMICAL'),
    (4, 'MOHAMMAD', 24, 'ELECTRICAL');

Now let’s verify whether the data is inserted or not.

SELECT * FROM Students;

Output:

You can see the table was created successfully.

In the changing world of a database, tables are the fundamental structures that organize and save data with precision. A table, in the context of a database, is a scientific arrangement of records offered in rows and columns. It improves the performance of information control and retrieval. In this article, we will go through the essential components of the table in the database. We will also examine the significance of the column names, data types, and key identifiers, including primary and foreign keys.