Advertisements
Advertisements
प्रश्न
Write a SQL statement to modify the student table structure by adding a new field.
Advertisements
उत्तर
Syntax:
ALTER TABLE < table-name > ADD < column name >< data type >< size > ;
Example:
ALTER TABLE student ADD (age integer (3)).
APPEARS IN
संबंधित प्रश्न
Write a query that selects all students whose age is less than 18 in order wise.
Differentiate Unique and Primary Key constraint.
Write the difference between table constraint and column constraint?
Write any three DDL commands.
Write the use of the Savepoint command with an example.
Write a SQL statement using the DISTINCT keyword.
Write the different types of constraints and their functions.
What are the components of SQL? Write the commands in each.
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.
