Jump to content

Talk:Data definition language

Page contents not supported in other languages.
From Wikipedia, the free encyclopedia

Merge

[edit]

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

[edit]

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

[edit]

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?

[edit]

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

[edit]

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

TRUNCATE being DDL/DML

[edit]

In the talk page for the TRUNCATE statement, there's discussion about TRUNCATE being DML or DDL. That discussion is of course also relevant for this page. Troels Arvin (talk) 07:38, 13 November 2024 (UTC)[reply]