What is data definition language? Explain it in detail?

The SQL DDL allows specification of not only a set of relations, but also information after each relation, containing

a) The schema for each relation

b) The domain of values associated with each attribute

c) The integrity constraints

d) The set of indices to be maintained for each relation

e) The security and authorization information for each relation

f)  The physical storage structure of each relation on disk

  Domain Types in SQL

Char(n),

varchar(n), int, small int, numeric(p,d), real, double, precision,

f loat(n), date, time, timestamp.

Schema Definition in SQL

a) Primary key

b) Check

 

Posted Date: 6/3/2013 2:45:18 AM | Location : United States

Ask an Expert

Related Discussions:- What is data definition language, Assignment Help, Ask Question on What is data definition language, Get Answer, Expert's Help, What is data definition language Discussions

Write discussion on What is data definition language
Your posts are moderated

Write your message here..

Related Questions

What is an e-r model and draw an e-r diagram for the company, What is an E-... What is an E-R model? Draw an E-R Diagram for the company database with following Descriptions? The company is organized within departments. Each department has a unique name a

What is functional dependency, A Functional dependency is described by ... A Functional dependency is described by X Y between two groups of attributes Y and X that are subsets of R specifies a constraint on the possible tuple that can make a relation

Define clause in sql to specify query result must be sorted, The clause in ... The clause in SQL which specifies that the query result should be sorted in ascending or descending order based upon the values of one or much more columns is Ans : Order by

What are the object-oriented approaches, What are the object-oriented appro... What are the object-oriented approaches Software systems which are designed with structured design methodology never support some of desired quality attributes for example reus

Database recovery and security, Database Recovery And Security Introdu... Database Recovery And Security Introduction In this part we will introduce two main issues relating to database management systems. A computer system suffers from dissi

Determine the advanced modeling concepts, Determine the Advanced modeling c... Determine the Advanced modeling concepts You have to follow some steps for object-oriented design. These steps for OO Design methodology are as follow:  1)  Produce objec

Each statement should have a where clause, Submit SQL SELECT Statements to ... Submit SQL SELECT Statements to demonstrate several reports off your database, according to the following guidelines: You must submit at least 5 SELECT Statements. Each

Linked list, what is difference between circular inked lust and grunded lin... what is difference between circular inked lust and grunded linked list

Designing a Human Resources Database LASA1, Scenario: You are a freelance ... Scenario: You are a freelance database designer who has just been contacted by a small software development company named Altair Software. The president of the company has asked

Entity integrity constraint - relational constraints, It defines that no pr... It defines that no primary key value can be null. This is as the primary key is used to recognize individual tuple in the relation. So we will not be able to recognize the records