CREATE TYPE dbo.TVP AS TABLE
      (
          ID int NOT NULL,
          Name char(10) NULL,
          DOB datetime NULL,
          PRIMARY KEY (ID)
      )
      
      
 ----  Drop the table type - this will fail if it is being used 
      DROP TYPE dbo.TVP
      GO