Knowledge Hub

 

SQL Server Tips: Primary Keys, Foreign Keys and Indexes

SQL Server Tips: Primary Keys, Foreign Keys and Indexes

When it comes to retrieving data from your tables, indexes play a fundamental role in finding that data you require and finding it fast. Pretty much every table you create will have an index of one type or another; whether it is a regular index, a primary key or a foreign key.

SQL Server Tips: Tables and Columns

SQL Server Tips: Tables and Columns

A database is made up primarily of tables, a table is made up of columns and rows and each row contains data for each column. When creating or modifying your database structure there are a few things that may save you time.

Navigation

Social Media