Alter table command, Database Management System

ALTER TABLE Command: This command is used for variation of existing structure of the table in the given situation:

  • When a new column is to be added to the table structure.
  • When the existing column definition has to be altered, i.e., changing the width of the data type or the data type itself.
  • When integrity constraints have to be dropped or included.
  • When a constraint has to be allowed or not allowed.



MODIFY ( ...);


ADD CONSTRAINT < constraint type>(field name);





You require to put many constraints like that the database integrity is not compromised.


Posted Date: 3/11/2013 12:56:35 AM | Location : United States

Related Discussions:- Alter table command, Assignment Help, Ask Question on Alter table command, Get Answer, Expert's Help, Alter table command Discussions

Write discussion on Alter table command
Your posts are moderated
Related Questions
Problem: A DBMS built for Online Transaction Processing (OLTP) is usually regarded as unsuitable for data warehousing. Each system is designed with a different set of requireme

What are the problems if one were not to normalize?  When do these problems surface?           Ans:  Database normalization, sometimes considered to as  canonical synthesis, is

You are required to program (in a high level language such as C, C++, Java) and implement a cache simulator which will have the following inputs and outputs:- INPUTS

What are the factors to be taken into account when choosing a RAID level? A) Monetary cost of extra disk storage requirements. B) Performance requirements in terms of number

What is relational model feature? A relational model feature is much more data independence than some other database models.

What is a state chart diagram? State diagrams (State Chart Diagram) explain all possible states that a particular object can get into, and how object's state changes as result

A database to track your progress in your college program will track your progress towards graduation! A database that has information containing the classes that you have taken, c

recovey techniques based on deferred update and immediate update

We are looking to find someone to prepare a database which improves upon the one we are using at present. The present database will be found here: Click on filter options and yo

What is Log Shipping? Log shipping is the method of automating the backup of database and transaction log files on a production SQL server, and then restoring them onto a stand