Write SQL code to manipulate column definitions, using DROP, RENAME, and TRUNCATE commands.
Writing code should include using the following DDL commands:
- DROP—deletes the entire table including the structure and data
- TRUNCATE—deletes the data content entered into the table, but leaves the structure of the table intact
- RENAME—changes the name of a table, view, sequence, or synonym
Related Standards of Learning
The student will design and apply computer programs to solve practical problems in mathematics arising from business and applications in mathematics.
The student will write program specifications that define the constraints of a given problem.