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

Consistency, what do you mean by consistency in rdbms?

what do you mean by consistency in rdbms?

Example database application, We will explain here an example database appl...

We will explain here an example database application having COLLEGE database and use it in showing several E-R modelling concepts. College database remains track of faculty, Stu

What type of view of total database content, What type of view of total dat...

What type of view of total database content? Data base content Conceptual view of total database contain.

Example of primary key, Suppose that in an organisation, an employee may do...

Suppose that in an organisation, an employee may do different roles in dissimilar projects. Say, RAM is doing coding in one project and doing designing in another. Suppose that the

Information infrasture, what benefit can a company gain by managing its own...

what benefit can a company gain by managing its own infrasture and services

Execute sql queries, Consider the relations described below: PHYSICIAN (re...

Consider the relations described below: PHYSICIAN (regno, name, telno, city) PATIENT (pname, street, city) VISIT (pname, regno, date_of_visit, fee) Where the regno and pname ide

File organisation and its types, File Organisation And Its Types Just ...

File Organisation And Its Types Just as arrays, trees, lists and other data structures are used to execute data Organisation in main memory, a number of planning's are used to

Schema, difference between internal schema and external schema in DBMS

difference between internal schema and external schema in DBMS

Define the terms - physical schema and logical schema, Define the terms 1)...

Define the terms 1) physical schema 2) logical schema. Physical schema: The physical schema explains the database design at the physical level, which is the lowest lev

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..

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages

Alter table command, Database Management System

Related Discussions:- Alter table command

Consistency, what do you mean by consistency in rdbms?

Example database application, We will explain here an example database appl...

What type of view of total database content, What type of view of total dat...

Example of primary key, Suppose that in an organisation, an employee may do...

Information infrasture, what benefit can a company gain by managing its own...

Execute sql queries, Consider the relations described below: PHYSICIAN (re...

File organisation and its types, File Organisation And Its Types Just ...

Schema, difference between internal schema and external schema in DBMS

Define the terms - physical schema and logical schema, Define the terms 1)...

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

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