Advertisements
Advertisements
Question
Write a SQL statement to modify the student table structure by adding a new field.
Advertisements
Solution
Syntax:
ALTER TABLE < table-name > ADD < column name >< data type >< size > ;
Example:
ALTER TABLE student ADD (age integer (3)).
APPEARS IN
RELATED QUESTIONS
The clause used to sort data in a database.
Differentiate Unique and Primary Key constraint.
Write a short note on Primary key constraints.
Write any three DDL commands.
Write the different types of constraints and their functions.
Consider the following employee table. Write SQL commands for the question.
| EMP CODE | NAME | DESIG | PAY | ALLO WANCE |
| S1001 | Hariharan | Supervisor | 29000 | 12000 |
| P1002 | Shaji | Operator | 10000 | 5500 |
| P1003 | Prasad | Operator | 12000 | 6500 |
| C1004 | Manjima | Clerk | 8000 | 4500 |
| M1005 | Ratheesh | Mechanic | 20000 | 7000 |
To remove the employees who are mechanics.
What are the components of SQL? Write the commands in each.
Construct the following SQL statement in the student table-
SELECT statement using GROUP BY clause.
Construct the following SQL statement in the student table-
SELECT statement using ORDER BY clause.
Write a SQL statement to create a table for employees having any five fields and create a table constraint for the employee table.
