Search notes:

SQL Server function: object_id

select object_id('information_schema.tables')

The returned object_id is needed for object_definition.

object_id comes in handy to check if a table exists before dropping it.

See also