SQL Server 2005+ -获取所有默认和检查约束

I have the following query (put on my dba hat today :)) and I was wondering if anyone knows of a better way to get the Default And Check constraints without a Union All. This would sure make adding a where clause easier and more efficient.I have the following query (put on my dba hat t