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
#queDefine a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pic

Benefits and limitations

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

How is the database organised in Oracle? Database organized within Oracle in terms of table and table holds attributes and values. A database consists of one or more logical


Process of Adjustment of inheritance During object design, inheritance is readjusted by rearranging classes and operations, and abstracting common behaviour.

Explain the Deferred Update The deferred update methods do not physically update the database on disk till after a transaction reaches its commit point; after that the updates

Question 1 Draw a Data Flow Diagram for a University scenario Question 2 Discuss the following with suitable examples Relational Algebra Operators Database Pla

write a database program for concurrency transaction in a bank

create an er diagram for production management in film industry