patternsqlMinor
List of Object properties
Viewed 0 times
propertieslistobject
Problem
Is there a function or system view that returns all of the available property names?
I was looking for 'SYSTEMDATAACCESS' and 'USERDATAACCESS' which aren't listed on the MSDN OBJECTPROPERTY page. I added a comment about them, but am wondering if there are others that I don't know about...given that it's SQL I'd expect them to be available as queryable metadata somewhere, but couldn't find anything. Are the properties in the meta data somewhere?
EDIT: While it isn't really relevant to my question, here is an example usage of system data access.
I was looking for 'SYSTEMDATAACCESS' and 'USERDATAACCESS' which aren't listed on the MSDN OBJECTPROPERTY page. I added a comment about them, but am wondering if there are others that I don't know about...given that it's SQL I'd expect them to be available as queryable metadata somewhere, but couldn't find anything. Are the properties in the meta data somewhere?
EDIT: While it isn't really relevant to my question, here is an example usage of system data access.
select OBJECTPROPERTY(OBJECT_ID('sys.dm_db_stats_properties'), 'SYSTEMDATAACCESS')Solution
Is there a function or system view that returns all of the available
property names?
No. There isn't even something that returns the names of all of the available built in functions (such as
These property values are documented for
For entirely undocumented property values (such as
property names?
No. There isn't even something that returns the names of all of the available built in functions (such as
OBJECTPROPERTY itself).These property values are documented for
OBJECTPROPERTYEX even though they do also appear to work for OBJECTPROPERTY and probably should be documented there (the return type is int so there is no reason that they shouldn't be supported there and it is more convenient to work with that function without needing a cast from sql_variant.)For entirely undocumented property values (such as
minlen for INDEXPROPERTY) I'm not aware of any way of determining these.Context
StackExchange Database Administrators Q#121712, answer score: 2
Revisions (0)
No revisions yet.