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.

Syntax

ALTER TABLE

ADD ( ...); ALTER TABLE
MODIFY ( ...);

ALTER TABLE

ADD CONSTRAINT < constraint type>(field name);

ALTER TABLE

DROP;

ALTER TABLE

ENABLE/DISABLE ;

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
What does data dictionary is a special file contains ? The data dictionary is a special file contain The name of all fields in all files.The width of all fields in all files an

Why Like predicate used for? LIKE predicate: The LIKE predicate searches for strings in which have a certain pattern.

Explain the θ-join and equijoin Refer tables Car and Boat which list models of cars and boats and their relevant prices. Assume a customer wants to buy a car and a boat, but sh

Need 2 projects completed in 3NF format.

What is persistency? Persistency ensures which data is stored and that after the object is no longer available (program stops running) the data will be available to other users

please describe the data base management with the easy example &give the application?

What is the use of integrity constraints? Integrity constraints make sure that changes made to the database by authorized users do not result in a loss of data consistency. The

Why a report generator is used ? Report generator is used for print files on paper.

Define the step - Rearranging the Execution Order for Efficiency As we know that algorithm and data structure are closely related to one another, but data structure is conside

Explain trigger? Trigger: A database trigger is procedural code which is automatically executed within response to certain events on a particular table in a database. Trigger