 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / General / Other SQL Server Topics / July 2005Lack of documentation
I'm trying to create a database table whose primary key comes from the pubs database, titles table. The column name from the titles table is title_id. Its data type is tid. What is tid? Example: BU1032 See the pubs documentation at: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_pubs _2v8l.asp It is a User Defined Datatype with the underlying real datatype of VARCHAR(6). You can find more info about UDT's in BooksOnLine but essentially it is a way to define a datatype in one place that you can then use in many tables and they will inherit the underlying datatype. It's main purpose is to make sure the datatypes are all defined the exact same way in each table where it is used. Sounds good in theory but if you need to make a change you must drop it from all the tables where it is being used first. I never recommend them for that reason alone.  SignatureAndrew J. Kelly SQL MVP > I'm trying to create a database table whose primary key comes from the > pubs [quoted text clipped - 3 lines] > See the pubs documentation at: > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_pubs _2v8l.asp And to add to Andy's comments, you can see the definition of any UDT with sp_help: EXEC sp_help tid SignatureHTH ---------------- Kalen Delaney SQL Server MVP www.SolidQualityLearning.com > I'm trying to create a database table whose primary key comes from the > pubs [quoted text clipped - 3 lines] > See the pubs documentation at: > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_pubs _2v8l.asp |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.