I want to retrieve the definition of a sequence through a query. I have already done this with triggers:
USE dbName
SELECT c.text FROM sys.syscomments c
INNER JOIN (
SELECT object_id FROM SYS.triggers WHERE name = 'triggerName'
) t ON c.id = t.object_id