Learn how to name tables and columns in a database for maximum efficiency, readability, and maintainability. Discover some naming conventions and standards for database administration.

Naming tables, columns, and constraints in a relational database schema is not just a matter of personal preference or style. It can have a significant impact on the readability, maintainability ...

When you copy a column that has an alias data type from one database to another, the alias data type may not be available in the destination database. In such a case, the column will be assigned the ...

The framework generates a sql statement that selects a column from a table where this column does not exists. Possibly the framework links a very different table just because of naming. Code to rep ...

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.

This statement can be embedded in an application program or issued through the use of dynamic SQL statements. It is an executable statement that can be dynamically prepared. Prevents the table from ...

SQL Server 2016 and Azure SQL Database both give you tables that automatically keep track of changes to your data. Here's how to both create those tables and alter existing tables so they track the ...

Designing an appropriate set of indexes can be one of the more troubling aspects of developing efficient relational database applications. Perhaps, the most important thing you can do to assure ...

Using default values on database columns helps to insulate database design issues from application code. Find out how to change a column's default value at a later date using a single command.