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
May – 2020 Edition
April – 2020 Edition
March – 2020 Edition
February – 2020 Edition
January – 2020 Edition
December – 2019 Edition
Punjab Civil Services 2020