Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
junior.skunk
Starting Member
1 Post |
 Posted - 2006-10-20 : 10:39:28
|
| Hello to everyone, I've a question about UDTs and the way I can use them to access tables and columns where they are applied in a SQL Server 2005 DB.I've already spent 2 days googling and MSDN reading but nothing helped me to solve my problem, thats why I'm posting it here (this is the second post, maybe the last one was in the wrong Forum).The scenario follows:I've created a UDT called MyUDT that exposes 2 properties MyTable, MyColumn, here its the code:[Serializable][SqlUserDefinedType(Format.UserDefined, IsByteOrdered = true, MaxByteSize = 8000, Name = "MyUDT")]public class MyUDT : INullable, IBinarySerialize{ private string _myTable; private string _myColumn;.... /// <summary> /// Set or Get the Table Name where the UDT is applied. /// </summary> public string MyTable { get { return this._myTable; } set { this._myTable = value; } } /// <summary> /// Set or Get the Table's Column Name where the UDT is applied. /// </summary> public string MyColumn { get { return this._myColumn; } set { this._myColumn = value; } }....}And here it's my question/s:How can I expose the defined Properties (MyTable, MyColumn) in order to be directly used from SQL Server Management Studio within the Column Properties Panel? Pls take a look to the print screen placed below:[url=http://img81.imageshack.us/my.php?image=untitledip1.jpg][img=http://img81.imageshack.us/img81/7193/untitledip1.th.jpg][/url] If it is not possible, is there a way for any UDT to get back from the sql server execution context the table and the column where it is applied/used?I need to solve that in order to later retrieve via SQL the Extended Table Properties where the UDT is used and make some work on presented MetaData. Thanks in advance, every answer/help will be very much appreciated.- Guido |
|
|
|
|
|
|
|
Expose UDT properties in SQL Server 2k5