SQLConfiguration SQLConfiguration


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.