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

Differentiate between logical database design and physical, Differentiate b...

Differentiate between logical database design and physical database design. Show how this separation leads to data independence? Basis Logical Databas

Create a e-r diagram or uml class diagram, We require an advanced system fo...

We require an advanced system for a Sports Centre, you are concerned only with representing the data discussed below about bookings and members. (The complete system may contain ot

What is abstraction, What is abstraction? Abstraction in the object ori...

What is abstraction? Abstraction in the object orientation is a idea that provide opportunity to express necessary properties of object without providing much details of the im

Define single valued and multivalued attributes, Define single valued and m...

Define single valued and multivalued attributes. Single valued attributes: attributes with a single value for a particular entity are known as single valued attributes. Mult

Define deadlock recovery measures, Define Deadlock recovery measures ...

Define Deadlock recovery measures To recover from deadlock, the cycle in the wait-for-graph should be broken. The common technique of doing this is to rollbac

Glory be, what does glory be mean

what does glory be mean

Explain the dependency relationship of object oriented, Explain the depende...

Explain the dependency relationship of object oriented A dependency is a relationship which states that a change in specification of one thing can affect another thing, but n

Give an example of operations from the functions of a bank, Give an example...

Give an example of Operations from the functions of a bank. For creation of a saving account, you can write: bank::: create -savings-account (customer)->account. For oper

Field, examples of fields in a database

examples of fields in a database

Subprograms, What is it ?

What is it ?

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages

Alter table command, Database Management System

Related Discussions:- Alter table command

Differentiate between logical database design and physical, Differentiate b...

Create a e-r diagram or uml class diagram, We require an advanced system fo...

What is abstraction, What is abstraction? Abstraction in the object ori...

Define single valued and multivalued attributes, Define single valued and m...

Define deadlock recovery measures, Define Deadlock recovery measures ...

Glory be, what does glory be mean

Explain the dependency relationship of object oriented, Explain the depende...

Give an example of operations from the functions of a bank, Give an example...

Field, examples of fields in a database

Subprograms, What is it ?

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