Alter table command, ALTER TABLE Command : This command is used for variation of existing, Database Management System

Alter table command, Database Management System

Assignment Help:

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.

Related Discussions:- Alter table command

Oracle, comparison of oracle RDBMS with MySQL

comparison of oracle RDBMS with MySQL

Mobile database, write short note on mobile database

write short note on mobile database

Explain data sublangauges, Explain Data Sublangauges ? Data sublanguage...

Explain Data Sublangauges ? Data sublanguage: In relational database theory, the term sublanguage, first used for this purpose through E. F. Codd in the year of 1970, refers t

What is distributed system, What is Distributed system ? Distributed S...

What is Distributed system ? Distributed System - A distributed system consists of a number of processing parts in which are interconnected through a computer network and in

xml, basic structure of xm

basic structure of xml

What are the uses of functional dependencies, What are the uses of function...

What are the uses of functional dependencies? To test relations to see whether they are legal under a given set of functional dependencies. To state constraints on the set

What three major types of actions includes databases, What three major type...

What three major types of actions includes databases? Briefly discuss these The three major types of actions including databases are: (i) Defining: It includes specifyin

Sparse and dense indexes, Sparse and Dense Indexes These indexes in pri...

Sparse and Dense Indexes These indexes in principle are the similar as that of indexes used at the back of the book. The key facts of the indexes are: They are arranged

Describe all integrity constraints which are violated, Consider the two rel...

Consider the two relations given below Given that A is the primary key of R, D is the primary key of S and there is a referential integrity among S.A and R.A, discuss all

Give a sample of the dynamic model, Give a sample of the Dynamic Model. ...

Give a sample of the Dynamic Model. The sample of dynamic model is given below: Dynamic model for the car: Brake and Accelerator Brake or Applies Accelerator

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages

Alter table command, Database Management System

Related Discussions:- Alter table command

Oracle, comparison of oracle RDBMS with MySQL

Mobile database, write short note on mobile database

Explain data sublangauges, Explain Data Sublangauges ? Data sublanguage...

What is distributed system, What is Distributed system ? Distributed S...

xml, basic structure of xm

What are the uses of functional dependencies, What are the uses of function...

What three major types of actions includes databases, What three major type...

Sparse and dense indexes, Sparse and Dense Indexes These indexes in pri...

Describe all integrity constraints which are violated, Consider the two rel...

Give a sample of the dynamic model, Give a sample of the Dynamic Model. ...

Write Your Message!

Featured Services

Online Tutoring

Project Development

Exam Preparation

Course Help

Assignment Help

Popular Subjects

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT