SQL Primer: An Accelerated Introduction to SQL Basics

©  Rahul Batra 2018

Rahul BatraSQL Primerhttps://doi.org/10.1007/978-1-4842-3576-8_4

4. Operations on Tables

Rahul Batra¹ 

(1)

Gurgaon, Haryana, India

 

Tables are the fundamental storage containers of the relational world. A database will typically contain many tables, each representing a collection of entities. As requirements evolve, so do the tables within a database and database administrators (DBA’s) routinely perform administrative operations on individual tables like deleting them or changing their definition. While typical database users are not granted permissions to perform such operations on large production databases, nonetheless it is important to be familiar with them for didactic purposes.

You might have noticed that we keep on making ...