Author: K Z

This SQL Server tutorial explains how to use the SQL Server ALTER LOGIN statement with syntax and examples. Description The ALTER LOGIN statement modifies an identity used to connect to a SQL…

Learn how to enable a foreign key in SQL Server with syntax and examples. Description You may encounter a foreign key in SQL Server (Transact-SQL) that has been disabled. You can enable…

Learn how to disable a foreign key in SQL Server with syntax and examples. Description Once you have created a foreign key in SQL Server, you may encounter a situation where you…

Learn how to drop a foreign key in SQL Server with syntax and examples. Description Once a foreign key has been created, you may find that you wish to drop the foreign key…

This SQL Server tutorial explains how to use Foreign Keys with "set null on delete" in SQL Server with syntax and examples. What is a foreign key with "Set NULL on delete"…

This SQL Server tutorial explains how to use Foreign Keys with cascade delete in SQL Server with syntax and examples. What is a foreign key with Cascade DELETE in SQL Server? A…

Learn how to create, drop, disable, and enable a primary key in SQL Server (Transact-SQL) with syntax and examples. What is a primary key in SQL Server? In SQL Server (Transact-SQL), a…

This SQL Server tutorial explains how to use Foreign Keys in SQL Server with syntax and examples. What is a foreign key in SQL Server? A foreign key is a way to…

The following is a list of topics that explain how to use Foreign Keys in SQL Server (Transact-SQL): Create Foreign Keys Create Foreign KeysCreate Foreign Keys with cascade deleteCreate Foreign…

This SQL Server tutorial explains how to use the TRUNCATE TABLE statement in SQL Server (Transact-SQL) with syntax and examples. Description The TRUNCATE TABLE statement is used to remove all records from…