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

Forward Recovery (Redo): In this system the committed changes made by a transaction are reapplied to a previous copy of the database.                          In simpler

Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4

What are the three types of data sources used with ODBC? An ODBC file data source is a file that can be shared between database users. An ODBC system data source is one that is

What are the advantages and disadvantages of using a database system. Sol. Advantages of Database System (DBMS) :  (1) Data Redundancy and Inconsistency: Since differen

System R was developed and designed over a period of 1974-79 at IBM San Jose Research Company. Its purpose was to illustrate that it is possible to create a Relational System tha

What is theta join explain? Theta  Join  - The  theta  join  operation  is  an  extension  to  the  natural-join operation which permits us to merge selection and a Cartesian

Briefly explain each of the following database terms. Use no more than 2-3 lines for each term. 1. DBMS 2. Update Anomaly 3. Alias (referring to tables in SQL queries)

Differance between procedural and non procedural DML? Procedural and non procedural DML Procedural DML exactly what data is require and how to obtain those data. Non procedural

Question 1 Explain the concept of Foreign Key. How a foreign key differs from a Primary Key? Can the Foreign Key accept nulls? Question 2 With a necessary example explain (i)