Computer Science, asked by tarunthapa7965, 3 months ago

Which query will remove this primary key constraint of admission no. in the student table

Answers

Answered by profdambaldor

2

Answer:

ALTER TABLE `mytable` CHANGE COLUMN `id` `id` INT(11) NOT NULL, DROP PRIMARY KEY;

Explanation:

Previous Question

Next Question

Similar questions

Math, 1 month ago

The coefficent of x^5 in 7x^4+9x^3+11x^2+20...

English, 1 month ago

DIARY ENTRY You recently participated in the All India CBSE National Quiz Competition and reached the finals. The final round was telecast over the national channel where you and your team won the quiz. Describe your feelings in 100-150 words through a diary entry.

English, 1 month ago

In your opinion, do all Americans have equal access to the American Dream? What are some of the factors that could make it easier or harder to achieve happiness in America? Why do you think Harlem Renaissance writers focused on the American Dream?

Math, 3 months ago

Read the following fractions and write the fractions...

English, 3 months ago

Ek Bar Ek Chitrakar Ek Mahal ko Se Ja Raha Tha Jab vah diwaron per Rang kar raha tha tab use Hriday Mein Apne Karya ko dusre Se Dekhne ki ichcha Hui...

Social Sciences, 9 months ago

6. How is land distributed amongst the farmers of village Palampur? Draw a pie diagram.

Economy, 9 months ago

06 The constitution is a combination of good features of several constitutions example.

Math, 9 months ago

divide 343 into 3 parts that half of the first part one third of the second part and one fourth of the third part are all equal .