[dbo].[management

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Heap
Row Count	0
Created	11:07:21 AM Wednesday, March 07, 2007
Last Modified	11:09:40 AM Wednesday, March 07, 2007

Property

Value

Collation

SQL_Latin1_General_CP1_CS_AS

Heap

Row Count

Created

11:07:21 AM Wednesday, March 07, 2007

Last Modified

11:09:40 AM Wednesday, March 07, 2007

Name	Data Type	Max Length (Bytes)
id	char(20)	20
createdate	int	4
createtime	int	4
createuser	varchar(32)	32
updatedate	int	4
updatetime	int	4
updateuser	varchar(32)	32
descr	varchar(255)	255

Name

Data Type

Max Length (Bytes)

Allow Nulls

char(20)

createdate

int

createtime

int

createuser

varchar(32)

updatedate

int

updatetime

int

updateuser

varchar(32)

descr

varchar(255)

255

Name	Columns	Unique
baseidx_management_groupid	id

Name

Columns

Unique

baseidx_management_groupid

SQL Script

CREATE TABLE [dbo].[management_groupid]
(
[id] [char] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[createdate] [int] NULL,
[createtime] [int] NULL,
[createuser] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[updatedate] [int] NULL,
[updatetime] [int] NULL,
[updateuser] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[descr] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_management_groupid] ON [dbo].[management_groupid] ([id]) ON [PRIMARY]
GO