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

Er diagram, er diagram of sport

er diagram of sport

Assign, #quesDefine a job scheduling strategy that will meet business requi...

#quesDefine a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pi

Er diatgrams, Ask q“A database will be made to store information about pati...

Ask q“A database will be made to store information about patients in a hospital. On arrival, each patient’s personal details (name, address, and telephone number) are recorded wher

Create the logical database schema, 1. Based on the dependency diagram, cr...

1. Based on the dependency diagram, create a database whose tables are in at least 2NF, showing the dependency diagram for each table (as shown in class). Label the types of depe

#Advantages of dbms.., #explain five disadvantages of a dbms..

#explain five disadvantages of a dbms..

How many levels can be viewed architecture of the database, How many levels...

How many levels can be viewed in Architecture of the database ? Architecture of the database can be viewed as three levels.

Explain candidate key, Explain Candidate key? Candidate Key - A candi...

Explain Candidate key? Candidate Key - A candidate key is a minimal superkey, that can be used to uniquely identify a tuple in the relation.

What is meant by buffer blocks and disk buffer, What is meant by buffer blo...

What is meant by buffer blocks and disk buffer The blocks residing temporarily in main memory are referred to as buffer blocks. The area of memory where blocks reside t

I want to get database of a website, Project Description: I would like t...

Project Description: I would like to get a database of a website which has clients email name and phone number. If you are able to get information from a website, by entering

ER model, coventions for displaying an ER schema as ER diagram

coventions for displaying an ER schema as ER diagram

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages

Alter table command, Database Management System

Related Discussions:- Alter table command

Er diagram, er diagram of sport

Assign, #quesDefine a job scheduling strategy that will meet business requi...

Er diatgrams, Ask q“A database will be made to store information about pati...

Create the logical database schema, 1. Based on the dependency diagram, cr...

#Advantages of dbms.., #explain five disadvantages of a dbms..

How many levels can be viewed architecture of the database, How many levels...

Explain candidate key, Explain Candidate key? Candidate Key - A candi...

What is meant by buffer blocks and disk buffer, What is meant by buffer blo...

I want to get database of a website, Project Description: I would like t...

ER model, coventions for displaying an ER schema as ER diagram

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