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

Architecture, With the help of a suitable diagram gives module wise explana...

With the help of a suitable diagram gives module wise explanation of system architecture of DBMS.on..

What is a transaction? and how does it differs from update, wh

Explain data models namely relational network - hierarchical, Explain the t...

Explain the three data models namely relational, network and hierarchical and evaluate their relative advantages and disadvantages. Hierarchical Model: In hierarchical model, da

Apriori algorithm-find all frequent large itemsets, Your friend owns a comp...

Your friend owns a computer store in Yuen Long, selling Desktop and Notebook PCs and other computer peripherals. Having been rather successful with his business there, he decided t

Describe the concept of aggregation, Aggregation Aggregation is strong...

Aggregation Aggregation is stronger form of association. It represents the "has-a" or "part-of" relationship. An aggregation association depicts a complex object which is comp

Update opreation, notes about update opreation

notes about update opreation

What are advantages of object models, What are advantages of object models?...

What are advantages of object models? Object models are efficient for communicating with the application experts and reaching a consensus about the significant aspects of the p

E-r model uses this symbol to represent weak entity set, E-R model uses thi...

E-R model uses this symbol to represent weak entity set ? A Doubly outlined rectangle symbol is used to represent weak entity set.

Why do you go for sorting your query results, Why do you go for sorting you...

Why do you go for sorting your query results? SQL SELECT command to fetch data from MySQL table. Whenever you select rows, the MySQL server is free to return them in any order

Clinic, Need a sample of a clinic database relationships

Need a sample of a clinic database relationships

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages

Alter table command, Database Management System

Related Discussions:- Alter table command

Architecture, With the help of a suitable diagram gives module wise explana...

What is a transaction? and how does it differs from update, wh

Explain data models namely relational network - hierarchical, Explain the t...

Apriori algorithm-find all frequent large itemsets, Your friend owns a comp...

Describe the concept of aggregation, Aggregation Aggregation is strong...

Update opreation, notes about update opreation

What are advantages of object models, What are advantages of object models?...

E-r model uses this symbol to represent weak entity set, E-R model uses thi...

Why do you go for sorting your query results, Why do you go for sorting you...

Clinic, Need a sample of a clinic database relationships

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