alter table command this command is used for

Question

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.

 

View Complete Question

Request for Solution File

Ask an Expert for Answer!!

Database Management System: alter table command this command is used for

Reference No:- TGS0209775

Expected delivery within 24 Hours

Have a Question? (oR Write a Review)

Write atleast 100 words!!

   Recent Questions Asked Database Management System

Q : guidelines for creation of table table name guidelines for creation of table table name should begin with an alphabet in table name single quotes and blank spaces are not allowed reserve words

Q : the management approach would advocate the the management approach would advocate the position that entrepreneurs can be made discuss the management approach to entrepreneurial theory by

Q : column constraints not null unique check primary column constraints not null unique check primary key default referenceson delete cascade using this key whenever a

Q : create table prodtranspno number 4ptype char 1 create table prodtranspno number 4ptype char 1 check ptype in irs qty number 5foreign key pno references product pno on delete cascade in the

Q : alter table command this command is used for 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

Q : ythetasininthetacosinthetathen find ythetasininthetacosinthetathen find dydividedthetasolution ythetasininthetacosinthetaapplying uv rulethen dydividedtheta sininthetacosintheta

Q : example -alter table emp modify empno number example -alter table emp modify empno number

Q : drop table commandwhen an existing object is not drop table commandwhen an existing object is not needed for further use it is always better to eliminate it from the database to remove the existing

Q : as spring approaches your design rm has been as spring approaches your design rm has been tasked with designing a two-lane highway in rural wyoming the highway descends a hill crosses a river