SQL Constraint and Keys Archives - Page 24 of 24

A sunlit gouache workshop shows a localized repair within an otherwise orderly ceramic inlay panel.

SQL SERVER – ReIndexing Database Tables and Statistics with Targeted Maintenance

January 31, 2007

Best Practices, SQL Constraint and Keys, SQL Cursor, SQL Index, SQL Joins, SQL Scripts, SQL Server DBCC, SQL Stored Procedure

ReIndexing Database tables starts with a measured maintenance need. I check the workload before choosing an index operation.

SQL SERVER – Query to Display Foreign Key Relationships and Name of the Constraint for Each Table in Database

November 1, 2006

Pinal Dave

SQL Tips and Tricks

SQL Constraint and Keys, SQL Scripts, SQL Stored Procedure

A long query on INFORMATION_SCHEMA views that shows foreign key relationships for each table: the table, column, referenced table and the constraint name.