Category: Reference

How to find constraint names

Ever tried to drop a DEFAULT CONSTRAINT, how do you find the constraint name – try this:

USE [<database>]

EXEC sp_helpconstraint [<schema>.<table_name>]

GO

I found that little tip here: http://www.mssqltips.com/tip.asp?tip=1425

Useful LINQ to SQL links

I like LINQ to SQL, but I get occasionally caught out when trying something that seems like it should work. It compiles fine, but when you run the code you get: “Static method blah blah blah has no supported translation to SQL.”

This http://msdn.microsoft.com/en-us/library/bb386970.aspx details what methods and types are supported by LINQ to SQL.

Goto http://msdn.microsoft.com/en-us/library/bb386934.aspx for a general reference.