Timeline for View Default value for User Defined Table Type columns in SQL Server
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 15, 2016 at 8:55 | comment | added | GHauan | Thanks again, Ryan. Marked Randolphs post as answer since it was a bit more easy to read (the results), but yours helped along. | |
| Nov 7, 2016 at 19:02 | history | edited | Ryan Cooper | CC BY-SA 3.0 |
added 476 characters in body
|
| Nov 7, 2016 at 18:59 | comment | added | Ryan Cooper | DECLARE @MyTable AS dbo.MyTableTable; select object_name(o.parent_object_id) as ObjectName , cl.name as ColumnName , o.name as DefaultName , c.text as DefaultDefintion , o.* from tempdb.sys.syscomments c join tempdb.sys.objects o on c.id = o.object_id join tempdb.sys.columns cl on cl.object_id = o.parent_object_id AND cl.default_object_id = o.object_id where o.type = 'D' | |
| Nov 7, 2016 at 18:59 | comment | added | Ryan Cooper | This is pretty hacky, but works in my test. | |
| Nov 7, 2016 at 18:33 | comment | added | GHauan | Thank you, but this does not seem to also show for user-defined-table-types. I cannot see the defaults from my user defined table type. | |
| Nov 7, 2016 at 18:20 | history | answered | Ryan Cooper | CC BY-SA 3.0 |