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 |
|
tuka
Starting Member
26 Posts |
 Posted - 2008-09-04 : 16:36:53
|
| Hi,I am trying to understand how to use User defined datatype. I am new to this feature...I ran the following snippet below as defined in http://doc.ddart.net/mssql/sql70/sp_addp_16.htmUSE masterEXEC sp_addtype ssn, 'VARCHAR(11)', 'NOT NULL'however I dont see the datatype in my definition when using the sql server management studio express. How can I get access to it and use it im my table definitions ?TIA |
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-09-04 : 17:24:37
|
| Did you want this in the master database? It should appear databases -> System Databases -> master -> Programmability -> Types -> User-defined Data Types. You may need to right-click on the folder & select "Refresh" if you have not already done so. |
 |
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-09-04 : 17:25:36
|
| You should now be able to usee it like this for example:CREATE TABLE test2 (col1 ssn) |
|
|
|
tuka
Starting Member
26 Posts |
Posted - 2008-09-04 : 17:59:56
|
| Thanks for the feedback !! Cheers |
|
|
|
|
|
|
How do I use User defined datatype