O'Reilly logo

Sams Teach Yourself SQL in One Hour a Day, Fifth Edition by Arie D. Jones, Ron Plew, Ryan Stephens

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

image

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required