Query to delete constraint from alter table, Database Management System

A constraint named less_than_20 was defined on the field date_of_birth of table student. Delete this constraint.

ALTER TABLE student DROP CONSTRAINT less_than_20;

Posted Date: 5/11/2013 2:43:20 AM | Location : United States







Related Discussions:- Query to delete constraint from alter table, Assignment Help, Ask Question on Query to delete constraint from alter table, Get Answer, Expert's Help, Query to delete constraint from alter table Discussions

Write discussion on Query to delete constraint from alter table
Your posts are moderated
Related Questions
A file manipulation command that extracts some of the records from a file is called ? A file manipulation command that extracts some of the records from a file is called SELECT

There are two major types of fragmentation: Horizontal& Vertical. Horizontal fragments, as the name suggests are subsets of tuples and vertical fragments are subsets of attributes

ADVANCE OBJECT DESIGN Introduction Analysis is the initial step of the OMT methodology. It is apprehensive with devising a precise, concise, correct and understandable mo


DROP TABLE Command: When an existing object is not needed for further use, it is always better to eliminate it from the database. To remove the existing object from the databas

Consider the relation schemas as follows. works (person name, company name, salary); lives (person name, street, city); located in(company name, city); managers (person name

triggering

1.  Develop a flowchart using the decision structure to solve the following problem. A Box Lunch Bonanza is a small catering company that offers 2 different types of box lunches

What is OCR? OCR (Optical Character Recognition) is a technology that enables you to change different types of machine-readable documents, like scanned paper documents, PDF fil

In order to keep pace with competitors, Space Ltd has decided to implement an ERP system in order to replace its old legacy and manual systems. Management does not have much knowle