National Lampoon - Every Issue from 1970 - 1998

Just saw that Netflix movie and was surprised that it was so difficult to find these online.  They were on the Internet Archive for a time, but perhaps due to legal issues, have been pulled.

There was a DVD-ROM or CD-ROM of the archive published, but not only no longer for sale, but not even available on eBay.

But I finally dug up the archive.

Here it is.

So here you go, enjoy:

http://www.microrican-gaming.com/NL/

https://web.archive.org/web/20170420082453/http://www.microrican-gaming.com/NL/

To View Constraints in SQL Server database

quick and dirty:
SELECT * FROM sys.objects
WHERE type_desc LIKE '%CONSTRAINT'



Clearer:

SELECT OBJECT_NAME(object_id) AS ConstraintName,

SCHEMA_NAME(schema_id) AS SchemaName,

OBJECT_NAME(parent_object_id) AS TableName,

type_desc AS ConstraintType

FROM sys.objects

WHERE type_desc LIKE '%CONSTRAINT'

For specific  table:

add the following to very end:
AND OBJECT_NAME(parent_object_id)= 'theNameOfYourTable'


thanks to: https://bhaveshgpatel.wordpress.com/2009/11/04/sql-server-list-all-constraints-of-database-or-table/