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 2022
ECGC PO Course 2022
SIDBI Grade A Course 2022
RBI Assistant Course 2022
SSC CHSL Course 2022
DSSSB JE Electrical 2022
Punjab Civil Services 2022
ESIC Deputy Director 2022