Search notes:

SQL Server function: object_definition

Use the object_id(…) function to find the id of a particular object, then use this id with object_definition to display the object's definition.

select 
  object_definition(
     object_id('information_schema.tables')
  )

See also