No products in the cart.

Different between drop table and drop …

CBSE, JEE, NEET, CUET

Question Bank, Mock Tests, Exam Papers

NCERT Solutions, Sample Papers, Notes, Videos

Install Now

Different between drop table and drop clause of alter table

Posted by Devananda Sabar 4 years, 6 months ago

CBSE > Class 12 > Computer Science

1 answers

Yogita Ingle 4 years, 6 months ago

Alter is used to modify an existing table, like adding a row or column. Alter preserves the existing data. Example, deleting a column won't affect the data in the other columns. Changing a column datatype will result in conversion of existing data, which may result in data loss when there are errors such as overflows, under flows, or integrity constraint violations.

Drop is used to remove a table completely. You can drop and then recreate a table, but you will lose all the data it. If that's an issue, then Alter is the preferred solution. However, not all changes you might want to a table definition can be done with Alter, so your only option might be to drop/create.

0Thank You

ANSWER

Related Questions

Your school has a document enlisting names of school students who have pass this year and taken admission in further courses. You have to edit the documents with the following changes: a) Find the word ‘utilitarian‘ and replace it with the word ‘pragmatic’ (Take care not to replace the word utilitarianism). b) The word college as it occurs in the text should be capitalize. Replace the word college with the correct capitalization i.e with College throughout the text using the appropriate option.

Posted by Anju Sharma 4 months, 4 weeks ago

CBSE > Class 12 > Computer Science

0 answers

1.1. In a table in MYSQL database, an attribute A of datatype varchar(20) Nes the value "Keshar The attribute S of datatype char(20) has value "Meenakshi". How many characters are occupied by attribute A and attribute 67 a. 20,6 6.6,20 ८. 9,6 d. 6,9

Posted by Durga Devi 4 months, 4 weeks ago

CBSE > Class 12 > Computer Science

0 answers

Write a program in python to accept a number and check whether the number is divisible by 3 as well as 5 otherwise decide : (a) Is the number divisible by 3 and not by 5 (b) is the number divisible by 5 and not by 3 (c) is the number neither divisible by 3 or by 5

Posted by Manu Singh 6 months, 3 weeks ago

CBSE > Class 12 > Computer Science

0 answers

What is mean by buffering in file handling?

Posted by Syedali Fathima 5 months, 3 weeks ago

CBSE > Class 12 > Computer Science

1 answers

This content has been hidden. One or more users have flagged this content as inappropriate. Once content is flagged, it is hidden from users and is reviewed by myCBSEguide team against our Community Guidelines. If content is found in violation, the user posting this content will be banned for 30 days from using Homework help section. Suspended users will receive error while adding question or answer. Question comments have also been disabled. Read community guidelines at https://mycbseguide.com/community-guidelines.html

Few rules to keep homework help section safe, clean and informative.

Don't post personal information, mobile numbers and other details.
Don't use this platform for chatting, social networking and making friends. This platform is meant only for asking subject specific and study related questions.
Be nice and polite and avoid rude and abusive language. Avoid inappropriate language and attention, vulgar terms and anything sexually suggestive. Avoid harassment and bullying.
Ask specific question which are clear and concise.

Remember the goal of this website is to share knowledge and learn from each other. Ask questions and help others by answering questions.

Posted by Manoj Kumar Manoj Kumar 7 months, 2 weeks ago

CBSE > Class 12 > Computer Science