Talk:Insert (SQL)

This article is within the scope of WikiProject Databases, a project which is currently considered to be inactive.DatabasesWikipedia:WikiProject DatabasesTemplate:WikiProject DatabasesDatabases

I want to create a new table that have the same structure of an existing table. I don't want the records to be inserted in new table. I want only the structure of existing table.

SQL:2003 says: CREATE TABLE new_table_name [(column_names)] AS <subquery> WITH [NO] DATA. DB2 uses CREATE TABLE new_table_name LIKE old_table_name; both is irrelevant to the INSERT statement, however. --Stolze 10:56, 30 October 2006 (UTC)[reply]

Merge

Recommend merging UPDATE, INSERT, DELETE, MERGE and SELECT statements into DML article and redirecting these statements there. Comments? SqlPac 05:16, 17 May 2007 (UTC)[reply]