Sample: TestDB

1. Setup SQL Server Express and start the LocalDB instance (reference).
2. Use Visual Studio's Server Explorer to create a new LocalDB database named "TestDB".
3. Use Visual Studio's SQL Server Object Explorer to run the following DDL:

USE [TestDB]
GO
/****** Object: Table [dbo].[Test] Script Date: 10/8/2017 3:22:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Test] (
    [TestID]        INT IDENTITY (1, 1) NOT NULL,
    [Code]               NVARCHAR (10)  NOT NULL,
    [Name]               NVARCHAR (50)  NOT NULL,
    [Description]        NVARCHAR (100) NULL,
    [CreatedBy]          NVARCHAR (10)  NOT NULL,
    [CreatedDate]        DATETIME       NOT NULL,
    [ModifiedBy]         NVARCHAR (10)  NULL,
    [ModifiedDate]       DATETIME       NULL
);
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_Test_Code]
    ON [dbo].[Test]([Code] ASC);
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_Test_Name]
    ON [dbo].[Test]([Name] ASC);