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
Question (a) Concurrent access to data from a database is a normal part of application program usage. Describe three approaches to concurrency control (b) Distinguish among

Question 1: (a) Explain the legal meaning of :- (i) Computer Service Person (ii) Data holding (b) Explain how the law ensures Data protection and Security. Qu

3. (10 points) Assume that you have been presented with the following relation for the Baxter Aviation database: Charters (Pilot#, Pilot name, Aircraft ID#, #seats, Village, Fligh

Let consider the given partial relation EMP. Let us make some sub-queries for them EMPNO ENAME JOB SAL DEPTNO 7566

Atomicity: It describes a transaction to be a one unit of processing. We can also say either a transaction will be finished completely or not at all. In the transaction example 1

Question (a) Differentiate between the following terms: (i) Distributed Database v/s Distributed Database management System (ii) Homogeneous Distributed Database v/s Hete

Create 1 experiment to demonstrate an aspect of query optimisation by using access-path structures (indexes), decomposition, or denormalisation. Once satisfied with your experiment

What are composite objects? Objects that have other objects are known as complex objects or composite objects.

Illustrate the Deployment Diagram A deployment diagram shows all nodes on network, their processor execution and interconnections. In a dynamic model, this is used to represen