Data definition language, Database Management System

Data Definition Language

It organises the data in the form of columns and rows. But what does the data field column of table accumulate? How do you describe it using SQL?

The Data definition language (DDL) defines a set of commands used in the modification and creation of schema objects such as indexes, tables, views etc. These commands give the ability to create, drop and alter these objects. These commands are linked to the management and administrations of the databases. Before and after every DDL statement, the current transactions are implicitly committed, that is changes made by these commands are permanently stored in the databases. Let us talk about these commands in more detail:

CREATE TABLE Command

Syntax:

CREATE TABLE

(

Column_name1 data type (column width) [constraints], Column_name2 data type (column width) [constraints], Column_name3 data type (column width) [constraints],

...............................................

);

Where table name assigns the name of the table, column name describes the name of the field, data type specifies the data type for the field and column width distribute specified size to the field.

 

 

 

Posted Date: 3/11/2013 12:54:27 AM | Location : United States







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

Write discussion on Data definition language
Your posts are moderated
Related Questions
What are domain constraints?  A  domain is  a  set  of  values  that  might  be  assigned to an attribute  .all  values that appear in a  column of a relation must be taken fro

Illustrate the statement 'Projection operation distributes over the union operation'. Give an example.    Ans: Π L (E 1 ∪ E 2 ) = (Π L (E 1 )) ∪ (Π L (E 2 ))   This says th

Build a database application for a sports league. Assume your application is to keep track of teams and equipment that is checked out to teams. Explain the steps that is needed and

Define the terms i) Entity set ii) Relationship set Entity set: The set of all entities of the similar type is termed as an entity set. Relationship set: The set of all rela

Wait-die" scheme : The idea is based on non-preventive method. It is based on a simple rule:                                 If Ti requests a database resource that is held by T

Special comparison operator used in where Clause a.   between. ...and...It gives range among two values (inclusive) Example: SELECT ENAME, SAL FROM EMP WHERE SAL BETWE

Clustering Indexes It may be an excellent idea to keep data of the students in the order of the programme they have registered as most of the data file accesses may need studen

What is the meaning of Data independence? Data independence means a programs that are not dependent on the physical attributes of data and a programs that are not dependent on

Using SQL create a view RS for the relations R and S. The view consists of the columns A and D renamed as X and Y in that order. Insert a tuple into it. Show the contents of t

How many levels can be viewed in Architecture of the database ? Architecture of the database can be viewed as three levels.