----  Create the data type 
      CREATE TYPE dbo.Phone
      FROM nvarchar (25) NULL

      
 ----  Create table using the data type 
      CREATE TABLE myTable
      (
          ID int NOT NULL,
          Phone dbo.Phone NULL
      )

      
 ----  Drop the data type - this will fail if it is being used 
      DROP TYPE dbo.Phone