Home Forums SQL Server 2008 SQL Server Newbies Creating a reference table. RE: Creating a reference table.

  • March 7, 2013 at 2:02 pm

    #1594695

    brian.geregach (3/7/2013)

    here is the information you were asking for:

    CREATE TABLE [dbo].[Tickets](

    [Ticket Number] [int] NOT NULL,

    [Priority] [smallint] NULL,

    [Assignee] [varchar](25) NULL,

    [Category] [varchar](25) NULL,

    [Vendor Ticket] [varchar](60) NULL,

    [Open Date] [date] NULL,

    [Opener] [varchar](30) NULL,

    [Closer] [varchar](30) NULL

    ) ON [PRIMARY]

    Also, I already own the Microsoft SQL Server 2012 T-SQL Fundamentals book by Ltzik Ben-Gan.

    Thank you for the advise.

    Brian

    Cool. Which columns were you thinking of moving into a child table? What have you considered as a possible key column to relate the two tables?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato