Find which table references a sequence qith the following statement:
SELECT s.object_id AS sequence_object_id,
s.name AS sequence_name,
OBJECT_SCHEMA_NAME(o.parent_object_id) + '.'
+ OBJECT_NAME(o.parent_object_id) AS table_name,
r.*
FROM sys.sequences s
CROSS APPLY sys.dm_sql_referencing_entities(
OBJECT_SCHEMA_NAME(s.object_id) + '.' + s.name,
'OBJECT'
) r
JOIN sys.objects o
ON o.object_id = r.referencing_id