Data definition language, Database Management System

Assignment Help:

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.

 

 

 


Related Discussions:- Data definition language

How can you map null values to other values while display, How can you map ...

How can you map NULL values to other values while display? IF( ) , IFNULL( ) keywords are used to do so. They are 'LIMIT' is used for the following kinds of problems: 1) Ans

What are advantages of object-oriented programming paradigm, What is the ma...

What is the major advantage of object-oriented programming paradigm? The ability to modify the explanation of an object without affecting the rest of the system is the main adv

What is de-normalization, What is De-normalization? De-normalization is...

What is De-normalization? De-normalization is the method of attempting to optimize the performance of a database by adding redundant data. It is sometimes essential because cur

Describe sequential file organization, Describe sequential file organizatio...

Describe sequential file organization.  Explain the rules for (i)  Inserting a new record. (ii)  Deleting an existing record.          Ans:A sequential f

Discuss the types of integrity constraints with example, Discuss the types ...

Discuss the types of integrity constraints in which must be checked for the update operations - Insert and Delete. Give examples. Insert operation can violet any of the subse

Difference between left outer join and right outer join, Difference between...

Difference between LEFT OUTER JOIN and RIGHT OUTER JOIN In left outer join tuples from the left-hand-side relation which do not match any tuple in the right-hand-side relation

Idea for fyp, want a idea for final year project

want a idea for final year project

Er diagram, Draw an ER diagram for company''s database schema

Draw an ER diagram for company''s database schema

List any two disadvantages of a database system, List any two disadvantages...

List any two disadvantages of a database system ? The disadvantages of database system are: • Database systems are difficult, complex, and time-consuming to design. • Substanti

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd