Post reply

Table of user defined type with MS SQL 2000/20005

  • April 13, 2006 at 3:50 am

    #168636

    Hi!

    I have a question about creating a user defined type: I'd like to create a table of employee objects which include objects of the type employee_t. I used this structure before in Oracle 9i and would like to know how it can be done with MS SQL Server 2000 or 2005, preferably with Enteprise Manager/Management Studio. Below is an example.

    CREATE TYPE employee_t AS OBJECT (

       name     VARCHAR(10)

       jobDesc  VARCHAR(15)

       ...

    )

    CREATE TABLE Employee of employee_t

    Regards,

    Timo

  • April 13, 2006 at 5:32 am

    #632314

    Check out "user-defined data types" in BOL. That should get you started.

  • April 13, 2006 at 6:50 am

    #632341

    Thank you for your propmt response!!

     

    I checked out BOL, but it looks like the only feature of SQL server regarding my issue seems to be the creation of a data type using the standard types. For example:

    telephone_number   VARCHAR(17)

    As I'd like to create tables of user defined types, it looks like I'll have to use Oracle.

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply