dbo.tbl_menu

Description

Properties

Name	Value
Collation
File Group
Filestream File Group
Is Partitioned	False
Partitioned Column
Partition Scheme
File Groups
Filestream Partition Scheme
Filestream File Groups
Heap	True
Full Text Catalog
Full Text
Compression	NONE
Row Count (~)	0
Created	11/19/2012 05:21:04
Last Modified	11/19/2012 05:21:04

Columns

Name	Data Type	Length	Precision	Not Null	Computed	Persisted
id	int	4	10	True	False	False
menutype	varchar	24	0	True	False	False
title	varchar	255	0	True	False	False
alias	varchar	255	0	True	False	False
note	varchar	255	0	True	False	False
link	varchar	1024	0	True	False	False
type	varchar	16	0	True	False	False
published	tinyint	1	3	True	False	False
parent_id	int	4	10	True	False	False
level	int	4	10	True	False	False
ordering	int	4	10	True	False	False
access	varchar	255	0	True	False	False
img	varchar	255	0	True	False	False
params	varchar		0	True	False	False

SQL Script

CREATE TABLE dbo.tbl_menu (
  id int NOT NULL,
  menutype varchar(24) NOT NULL,
  title varchar(255) NOT NULL,
  alias varchar(255) NOT NULL,
  note varchar(255) NOT NULL,
  link varchar(1024) NOT NULL,
  type varchar(16) NOT NULL,
  published tinyint NOT NULL,
  parent_id int NOT NULL,
  level int NOT NULL,
  ordering int NOT NULL,
  access varchar(255) NOT NULL,
  img varchar(255) NOT NULL,
  params varchar(max) NOT NULL
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

Depends On

No items found

Used By

No items found