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