Shows whether or not the column's data type allows null values. Collation Shows the collation setting for the selected column. The collation can be set in the Column Properties tab of Table Designer.

When you query SAS tables, relations provide a way to identify rows and to relate (or join) rows in one table to rows in another table. You define a relation on one or more columns in a table.

Query Builder is a user-friendly visualization tool that will help you make sense of your complex database designs. It can be useful when you need to understand the various relationships between ...

In an earlier column, I suggested that one way to speed up your application was to reduce the trips you make to your database, specifically by avoiding calling a stored procedure multiple times.To ...

Dozens of Boolean columns that were named Flag1, Flag2, ActiveFlag, Flag44, FlagIsBob and so on, each successive column named more mysteriously than the last. "Yeah, the old table was pretty messy," ...

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.