15. A computer program product stored in a computer readable device, comprising computer instructions that, when executed by an information handling system, causes the information handling system to copy records between tables in a relational database by performing actions comprising: receiving a Structured Query Language (SQL) table COPY statement, wherein the COPY statement is devoid of an INSERT clause and identifies a source table and a target table; retrieving a plurality of column names from a metadata corresponding to the source table; and generating an SQL statement, based upon the COPY statement, that includes an INSERT INTO clause pertaining to the target table and a SELECT clause pertaining to the source table, wherein the INSERT INTO clause includes a set of target column names corresponding to the plurality of column names, and wherein the SELECT clause includes a set of corresponding source column names.
17. The computer program product of claim 15 , wherein the COPY statement further identifies a DROP clause, and wherein the actions further comprise: receiving a DROP clause predicate corresponding to the identified DROP clause, wherein the DROP clause predicate identifies a drop column name; removing one of the source column names from the SELECT clause, wherein the removed source column name matches the drop column name; and removing one of the target column names from the INSERT INTO clause, wherein the removed target column name matches the drop column name.