/*顯示資料內所有約束*/
SELECT * FROM sys.default_constraints WHERE parent_object_id = OBJECT_ID('A_TMP')
/*找詢約束*/
if (SELECT count(name) FROM sys.default_constraints WHERE parent_object_id = OBJECT_ID('A_TMP') and name='A_prod_name')>0
begin
print '1'
end
else
begin
print '0'
end