Advertisements
Advertisements
प्रश्न
Write a short note on Primary key constraints.
उत्तर
Primary Constraint:
- Primly Constraint declares a field as a Primary key which helps to uniquely identify a recor<}ll
- Primary Constraint is similar to a unique constraint except that only one field of a table can be set as the primary key.
- The primary key does not allow NULL values and therefore a field declared as the primary key must have the NOT NULL constraint.
APPEARS IN
संबंधित प्रश्न
The command to delete a table is ______
The clause used to sort data in a database.
Differentiate Unique and Primary Key constraint.
Write the difference between table constraint and column constraint?
Which component of SQL lets inserts values in tables and which lets to create a table?
Write a SQL statement to modify the student table structure by adding a new field.
Write the use of the Savepoint command with an example.
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 display the details of all employees in descending order of pay.
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.
