[SQL Server] Object Definition

[Pepper Mint]

Hello experts,
I would like to learn the implementation of object_definition function in SQL server. I'd like the one with 2 parameters. Could you help me ? Thank you.

 

[DaveC426913]

What have you learned so far from reading and researching? Do you have specific questions?

 

[Pepper Mint]

What have you learned so far from reading and researching? Do you have specific questions?

I would like to know what this does in SQL Server
e.g object_definition(object_id, column_id)
I know it will return me something, e.g a text string and I think this returned value should be stored somewhere else I just have no clue where it is taken from. I think someone here would probably know this better than I do.

 

[Filip Larsen]

Perhaps you can find something interesting searching T-SQL on MSDN, like OBJECT_DEFINITION or OBJECTPROPERTY.

 

[DaveC426913]

Pepper, it is PF's policy to not spoon-feed answers to member questions. It is actually a rules requirement that you make some effort to find an answer yourself before we can give much more help than provding hints and pointing you at reading material.

 

[WWGD]

Pepper, why don't you execute it, i.e., run it? If you don't have SQL server, it is easy to download a free copy.

 

[Pepper Mint]

Pepper, why don't you execute it, i.e., run it? If you don't have SQL server, it is easy to download a free copy.

Thanks WWGD, I just ownloaded SQL Server 2016 Express edition and learn something new about T-SQL.

 

[WWGD]

Thanks WWGD, I just ownloaded SQL Server 2016 Express edition and learn something new about T-SQL.

No problem, glad you did, why don't you tell us how it turned out?

 

[Pepper Mint]

No problem, glad you did, why don't you tell us how it turned out?

It turned out to be really cool. I know how to get schema id, table id with objectproperty.