How to list the constraints for all tables with identity insert of a database in SQL server?

See more:

SQL

How to  find constraints for tables with identity insert for a database in Sql server?

I am able to get the Tables with Identity Insert wit

How to  list the  constraints for all tables with identity insert of a database in SQL server?h below query
<pre lang="SQL">       select TABLE_NAME
       from INFORMATION_SCHEMA.COLUMNS
       where TABLE_SCHEMA = 'dbo'
      and 
COLUMNPROPERTY(object_id(TABLE_NAME), COLUMN_NAME, 'IsIdentity') = 1
      ORDER BY ORDINAL_POSITION</pre>

I need to fetch the constraints of the tables  with identity insert column alone.
I am able to fetch all constraints for a DB with below query. but it's needed for tables with identity insert alone
<pre lang="SQL">SELECT OBJECT_NAME(OBJECT_ID) AS NameofConstraint,
SCHEMA_NAME(schema_id) AS SchemaName,
OBJECT_NAME(parent_object_id) AS TableName,
type_desc AS ConstraintType
FROM sys.objects
WHERE type_desc LIKE &#39;%CONSTRAINT&#39;</pre>

What I have tried:

select TABLE_NAME
from INFORMATION_SCHEMA.COLUMNS
where TABLE_SCHEMA = 'dbo'
and
COLUMNPROPERTY(object_id(TABLE_NAME), COLUMN_NAME, 'IsIdentity') = 1
ORDER BY ORDINAL_POSITION

I am able to fetch all constraints for a DB with below query. but it's needed for tables with identity insert alone

SELECT OBJECT_NAME(OBJECT_ID) AS NameofConstraint,
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'