Execute the following script in Query Editor to demonstratate the use of object_id, object_schema_name, object_name and object_definition system functions:

/*

OBJECT_DEFINITION applies to the following object types:

C = Check constraint

D = Default

P = SQL stored procedure

FN = SQL scalar function

R = Rule

RF = Replication filter procedure

TR = SQL trigger

IF = SQL inline table-valued function

TF = SQL table-valued function

V = View

*/

USE AdventureWorks2008;

SELECT object_id ('HumanResources.uspUpdateEmployeeHireInfo')

GO

-- 87671360

SELECT object_schema_name(87671360),object_name(87671360)

GO

-- Returns object create statement

SELECT object_definition(87671360)

GO