Activity overview
Latest activity by debry
I don't think it's possible for a table to have a default constraint or a calculated field based on a function that takes a table-valued parameter as an input. How would the UDTT be initialized? I'll see if I can re-create the scenario, but either way, one solution to this problem would be to allow users to select / deselect specific objects in the dependency list. That way it's not an "all or nothing" feature. Has this been proposed before? / comments
I don't think it's possible for a table to have a default constraint or a calculated field based on a function that takes a table-valued parameter as an input. How would the UDTT be initialized?I'l...
Dependencies on User Defined Table Types
User Defined Table Types cannot be altered directly. First, all the dependencies on that type need to be dropped, then the table type is altered, then the dependencies are re-created. It's an annoy...
Thanks Eddie. Sorry, I didn't mean the extended properties in isolation. What I meant to ask is there a way to filter on objects (for example, tables) based on the extended properties associated with them? / comments
Thanks Eddie. Sorry, I didn't mean the extended properties in isolation. What I meant to ask is there a way to filter on objects (for example, tables) based on the extended properties associated wi...
Filter objects on extended properties?
In the custom filter rules, it appears that the only filter options are on name or schema. Is it possible to filter on other properties, specifically the extended properties?