Tag: composite-key

why empty values are allowed but not null values in composite primary keys

composite-key database primary-key snowflake-cloud-data-platform sql

I am working on an App connecting to the Snowflake database. I stumbled upon an issue while loading CSV files. I was using the NULL_IF condition in copy command to change column value to null if any empty value is encountered during the load On investigation, I came to know that one of the columns is part of …

Sharing composite foreign key based on the same columns across multiple tables in MS SQL Server

composite-key foreign-keys sql sql-server

I have database with multiple tables which contains information about different instruments (Currencies, Funds, Equities etc.). All instruments have Type and Id fields which represents unique key for …