12. The information handling system of claim 9 wherein the COPY statement further identifies a WHERE clause that includes a WHERE clause expression, and wherein the actions performed further comprise: including the WHERE clause in the generated SQL statement.
9. An information handling system comprising: a plurality of processors; a memory coupled to at least one of the processors; a set of instructions stored in the memory and executed by at least one of the processors to copy records between tables in a relational database, wherein the set of instructions perform actions of: 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.