Sams Teach Yourself SQL in One Hour a Day, Fifth Edition

APPENDIX EGlossary of Common SQL Commands

*

The asterisk character returns all the columns of a particular table.

ALTER DATABASEALTER DATABASE database_name;

The ALTER DATABASE statement changes the size or settings of a database. Its syntax varies widely among different database systems.

ALTER USERALTER USER user

The ALTER USER statement changes a user’s system settings such as a password.

BEGIN TRANSACTION

The BEGIN TRANSACTION statement signifies the beginning of a user transaction. A transaction ends when it is either committed (see COMMIT TRANSACTION) or canceled (see ROLLBACK TRANSACTION). A transaction is a logical unit of work.

CLOSE ...