blog@eriköjebo.se

/lambλda/calculus/

$ login
$ ls -d /*/
  • /CodeBlog
  • /FamilyBlog
  • /AboutMe
  • /ContactMe
  • $ cat "

    Listing All Constraints in a SQL Server Database using T-SQL

    "

    Here is a short T-SQL snippet showing how to list all constraints in a database matching a given string:

    SELECT * FROM sys.objects
    WHERE type_desc LIKE '%CONSTRAINT' and name like 'DF%'
    Written by Erik Öjebo 2013-12-01 20:10 Comments (0)
Previous Next
$ info

Erik Öjebo

I'm a programmer, father, consultant and emacs enthusiast living in Örebro, Sweden. I specialize in .NET development using agile practices. I spend my time working on open source software and learning interesting programming languages such as lisp, ruby and haskell (using emacs, of course). More

profile for Erik Öjebo at Stack Overflow, Q&A for professional and enthusiast programmers
x