Talk:Data definition language
This article is rated Start-class on Wikipedia's content assessment scale. It is of interest to the following WikiProjects: | ||||||||||||||||||
|
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)
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)