Table Column Attributes  «Prev  Next»

Create Transact SQL Datatype - Exercise

Objective:> Create your own datatype.

Exercise scoring

This exercise is worth a total of 5 points. You will receive up to 5 points for submitting the correct Transact-SQL syntax required to create your own datatype.

Instructions

Construct a Transact-SQL statement that creates a user-defined datatype with these attributes:
  1. Name of zipcode
  2. Use exactly 5 characters for the datatype
  3. Allow null values

Submitting the exercise

Type or paste your code into the text box below, then click Submit to submit your answer and view a results page.