1. Learn
    2. /
  2. Courses
    3. /
  3. Hierarchical and Recursive Queries in SQL Server

Exercise

Creating a table

In this exercise, you will create a new table Person. For this task, you have to

  • define the table by using CREATE TABLE
  • define the necessary fields of the desired table

An example for creating a table Employee is shown below:

CREATE TABLE Employee (
    ID INT,
    Name CHAR(32)
);

Your task is to create a new table, Person, with the fields IndividualID,Firstname,Lastname, Address, and City.

Instructions

100 XP
  • Define the table Person.
  • Define a field IndividualID.
  • Set Firstname and Lastname not to be NULL and of type VARCHAR(255).
  • Define Birthday as DATE.