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
Punjab Civil Services 2021