Talk:Data definition language

From WikiProjectMed
Jump to navigation Jump to search

Merge

Recommend merging CREATE, DROP, ALTER statements into DDL article and redirecting these statements there. Please post comments here by 19 May 2007. SqlPac 05:10, 17 May 2007 (UTC)[reply]

Agreed. JD Lambert 21:54, 8 June 2007 (UTC)[reply]


Merged and Redirected to Data Definition Language

Merged CREATE (SQL), DROP (SQL), ALTER (SQL) articles with Data Definition Language and redirected them here. SqlPac 17:46, 9 June 2007 (UTC)[reply]

Additional example of ALTER

I removed the following example from the ALTER section as it was in the wrong place (inside a block that was supposed to contain a specific example of adding "bubbles" to "sink") There are some grammar errors and shorthand used as well. I don't have time to fix it, but if someone else would like to clean it up and re-add it, here is the original text that I removed:

some more examples if you have an example like following...
Alter table customer modify(name varchar2(20),cus_id number(10));
Before going to use this "Alter" cmds we have to create a table called customer.
To create the table use following codings on your coding area.
create table customer(name varchar2(10),cus_id number(10));

Cecilkorik (talk) 19:49, 19 January 2011 (UTC)[reply]

SHOW statement? Self-referential DML?

If I don't see a response explaining why not to do it, I plan to add one or two sections as soon as I can get around to it. (1) Besides the verbs used to manipulate the data definition, there should be (IMHO) some discussion about how to discover current definitions. At a minimum, the SHOW statement should also be discussed. (2) Due in large part to a lack of standardization of DDL, most DMLs provide a DML interface that can be used as a DDL. A table showing correspondences between DDL and equivalent DML would be very useful. Vrmlguy (talk) 12:07, 7 January 2013 (UTC)[reply]

DOML, TDML - DDL

I think it is DOML - data object manipulation language or TDML - Table description manipulation language. DDL is confusing