Skip to content

Instantly share code, notes, and snippets.

@jinan-kordab
Created October 16, 2018 02:08
Show Gist options
  • Select an option

  • Save jinan-kordab/f307cddd709fe2ec9434f6d2153edce1 to your computer and use it in GitHub Desktop.

Select an option

Save jinan-kordab/f307cddd709fe2ec9434f6d2153edce1 to your computer and use it in GitHub Desktop.
Creating table NavigationMenu for Dynamic Navigation Menu
USE [NavMenuDB]
GO
/****** Object: Table [dbo].[NavigationMenu] Script Date: 2018-02-27 19:23:24 ******/SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[NavigationMenu](
[LinkId] [bigint] IDENTITY(1,1) NOT NULL,
[LinkLevel] [int] NOT NULL,
[Linktype] [nvarchar](50) NOT NULL,
[ParentLink] [bigint] NOT NULL,
[LinkOrder] [int] NOT NULL,
[LinkText] [nvarchar](50) NOT NULL,
[HasChildren] [bit] NOT NULL,
[Class] [nvarchar](50) NULL,
CONSTRAINT [PK_NavigationMenu] PRIMARY KEY CLUSTERED
(
[LinkId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]) ON [PRIMARY]
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment