Chapter 4
Tables and CRUD Operations
Now that you have seen how to create and manage databases and files, it's time to take the next step and actually put something in the database. Obviously, a database is a big container—that's all, a container just begging for something to be put inside. Generally, we put two kinds of artifacts into a database: tables and indexes. All of the other artifacts (such as stored procedures, functions, and views) are actually stored in system table structures. A table is the most fundamental component that you will work with in SQL Server.
Tables, however, are just containers, and the ultimate goal is to get data into the tables for storage and then manipulate that data at will. The table defines the structure that ...
Get Mastering SQL Server® 2008 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
