O'Reilly logo

Sams Teach Yourself ADO.NET in 24 Hours by Paul Bertucci, Jason Lefebvre

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

Crash Course on Database Schema

In a database, such as Microsoft SQL Server, data is stored and organized in tables. Tables consist of a set of columns and a set of rows. The columns (also referred to as “fields”) define what information you are storing about your object (such as name, description, color, and so on). The columns define how your data will look. This is referred to as the database schema. The rows (also referred to as “records”) are your data—each row represents a group of columns of information.

A primary key is a column in your table that guarantees row-level accessibility. This sounds more complicated than it really is. Think of the data in a table organized like a spreadsheet. To access a particular row, the data provider needs ...

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