Ga naar inhoud

Userdefinedtypes

User Defined Types

The following types are defined and used where possible.

  1. Boolean 

    CREATE TYPE dbo.Boolean FROM bit not NULL;

  2. code 

    CREATE TYPE dbo.Code FROM Nvarchar(10) NULL;

  3. shortname 

    CREATE TYPE dbo.ShortName FROM Nvarchar(20) NULL;

  4. name 

    CREATE TYPE dbo.Name FROM Nvarchar(50) NULL;

  5. longname 

    CREATE TYPE dbo.LongName FROM Nvarchar(100) NULL;

  6. description 

    CREATE TYPE dbo.Description FROM Nvarchar(200) NULL;

  7. Pointer 

    CREATE TYPE dbo.Pointer FROM Bigint NULL;

  8. Amount 
    CREATE TYPE dbo.Amount FROM Decimal(18,4) NULL;
  9. Memo 
    CREATE TYPE dbo.Memo FROM NVARCHAR(Max) NULL;