A table is basic entity in relational databases where actual data is stored. Table is also called as Entity. Table consists of rows and columns. Each row represents the instance of entity that table represents.
We will not discuss all these, we will only see the add example. Suppose we want to add another column in Student Table namely Gender:
ALTER TABLE Student ADD Gender VARCHAR(6);
This statement will add column named Gender in Student table which of data type string having length as 6 characters.
Download as PDF
Read next: SQL – Data Manipulation Language ››
« Back to Course page
SBI Clerk Course 2024
ECGC PO Course 2024
SIDBI Grade A Course 2024
RBI Assistant Course 2024
SSC CHSL Course 2024
DSSSB JE Electrical 2024
Punjab Civil Services 2024
ESIC Deputy Director 2024