----  Create the assembly reference that contains the type definition 
      CREATE ASSEMBLY utf8string
      FROM '\\ComputerName\utf8string\utf8string.dll' ;
      GO

      
 ----  Create the new data type 
      CREATE TYPE Utf8String
      EXTERNAL NAME utf8string.[Microsoft.Samples.SqlServer.utf8string];
      GO

      
 ----  Create a table that uses the data type 
      CREATE TABLE dbo.myTable
      (
        ID		int NOT NULL,
        Name	Utf8String
      )
      GO

      
 ----  Drop the new data type 
      DROP TYPE Utf8String;
      GO