Talk:Data definition language

From Wikipedia, the free encyclopedia
Jump to: navigation, search
WikiProject Computing (Rated Start-class)
WikiProject icon This article is within the scope of WikiProject Computing, a collaborative effort to improve the coverage of computers, computing, and information technology on Wikipedia. If you would like to participate, please visit the project page, where you can join the discussion and see a list of open tasks.
Start-Class article Start  This article has been rated as Start-Class on the project's quality scale.
 ???  This article has not yet received a rating on the project's importance scale.
 
WikiProject Databases / Computer science  (Rated Start-class, High-importance)
WikiProject icon This article is within the scope of WikiProject Databases, a collaborative effort to improve the coverage of database related articles on Wikipedia. If you would like to participate, please visit the project page, where you can join the discussion and see a list of open tasks.
Start-Class article Start  This article has been rated as Start-Class on the project's quality scale.
 High  This article has been rated as High-importance on the project's importance scale.
Taskforce icon
This article is supported by WikiProject Computer science (marked as High-importance).
 

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)

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


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)

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)

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)