Term
| How to create a new table and populate it with data from an existing table |
|
Definition
CREATE TABLE command for structure
INSERT INTO ___
SELECT ___
FROM ___
WHERE ___ |
|
|
Term
| Changes in table structure |
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
| Changes column characteristics |
|
|
Term
|
Definition
|
|
Term
| Changes made to table contents are not physically saved on disk until |
|
Definition
Database is closed
Program is closed
COMMIT command is used |
|
|
Term
|
Definition
| Will permanently save any changes made to any table's contents in the database |
|
|
Term
|
Definition
| Undoes changes since last COMMIT |
|
|
Term
|
Definition
Only work with DML commands to add, modify, or delete table rows
Support transactions |
|
|
Term
|
Definition
A logical unit of work
Sequence of steps that accomplish a single task |
|
|
Term
|
Definition
|
|
