Login
Remember
Register
Ask Kuerp
Questions
Unanswered
Users
Ask a Question
Ask a Question
Write an SQL command to remove the Primary Key constraint from a table, named MOBILE. M_ID is the primary key
0
votes
28
views
asked
4 days
ago
in
Computer Science
by
Amrita
(
8.5k
points)
A) Write an SQL command to remove the Primary Key constraint from a table, named MOBILE. M_ID is the primary key of the table.
OR
B) Write an SQL command to make the column M_ID the Primary Key of an already existing table, named MOBILE.
Please
log in
or
register
to answer this question.
1
Answer
0
votes
answered
4 days
ago
by
Kunal
(
56.5k
points)
Best answer
A) ALTER TABLE MOBILE DROP PRIMARY KEY;
OR
B) ALTER TABLE MOBILE ADD PRIMARY KEY (M_ID);
Please
log in
or
register
to add a comment.
Related questions
0
votes
1
answer
14
views
A table, named STATIONERY, in ITEMDB database, has the following structure: Field Type itemNo int(11) itemName
asked
4 days
ago
in
Computer Science
by
Amrita
(
8.5k
points)
0
votes
1
answer
25
views
Write any two ways to add an audio file in a web page using HTML? Explain with sample code
asked
Sep 11
in
Computer Science
by
Amrita
(
8.5k
points)
0
votes
1
answer
650
views
Conservation of forest is a key to the survival of human mankind. Some of the practices undertaken in India
asked
Sep 5
in
Social Science
by
Amrita
(
8.5k
points)
0
votes
1
answer
17
views
Assertion (A): A SELECT command in SQL can have both WHERE and HAVING clauses.
asked
5 days
ago
in
Computer Science
by
Amrita
(
8.5k
points)
0
votes
1
answer
12
views
What constraint should be applied on a table column so that duplicate values are not allowed in that column
asked
4 days
ago
in
Computer Science
by
Amrita
(
8.5k
points)
Categories
All categories
English
(23)
Science
(37)
Social Science
(27)
Home Science
(15)
Computer Science
(30)
Other
(3)
Business Studies
(14)
Economics
(13)
Accountancy
(5)
Geography
(5)
...