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
Database Errors: An error is said to have occurred if the implementation of a command to manipulate the database cannot be successfully finished either due to inconsistent data or

How are tables stored on Disk? We realise that every record of a table can have different amounts of data. This is due to in some records; some attribute values may be "zero".

What is the need of a log in a DBMS? Briefly describe the various types of records that are normally present in a log.            Ans:  The system log, which is generally writt

For Colorado customers calculate the number of single products ordered. If a product is purchased on multiple orders, it should be counted only single time. The result should conta

Explain the conventions for displaying an ER schema as an ER diagram? An E-R Diagram scheme might describe certain constraints to that the contents of a database must conform.


Record based Logical Models: Use records as the key data representation components Examples: Relational Model: It shows data as well as relationship between data in the form

What is the main advantage of the object model? What are its different components? The object model focuses on the logical data structures. Each object model comprises of many

What are the benefits of document scanning? Document scanning, in addition to being cost-efficient, also enhances productivity. This service enhances security as you set the pa

Ask question #MinimRead Dennis et al. Chapter 6: Minicase 2. Work through it and answer the questions. See the attached example. SequenceDiagram.png Based on the structural mod