[dbo].[Divisions]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	2
Created	12:44:44 PM Thursday, October 04, 2007
Last Modified	12:44:47 PM Thursday, October 04, 2007

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

12:44:44 PM Thursday, October 04, 2007

Last Modified

12:44:47 PM Thursday, October 04, 2007

Name	Data Type	Max Length (Bytes)	Identity	Default
divisionID	int	4	-1 - 1
divisionName	nvarchar(100)	200
loginType	nvarchar(30)	60		(N'reg')
status	int	4		((1))

Name

Data Type

Max Length (Bytes)

Allow Nulls

Identity

Default

divisionID

int

-1 - 1

divisionName

nvarchar(100)

200

loginType

nvarchar(30)

(N'reg')

status

int

((1))

	Name	Columns	Unique
	pk_divisions	divisionID

Name

Columns

Unique

pk_divisions

divisionID

SQL Script

CREATE TABLE [dbo].[Divisions]
(
[divisionID] [int] NOT NULL IDENTITY(-1, 1),
[divisionName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[loginType] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__Divisions__login__7C8480AE] DEFAULT (N'reg'),
[status] [int] NULL CONSTRAINT [DF__Divisions__statu__7D78A4E7] DEFAULT ((1))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Divisions] ADD CONSTRAINT [pk_divisions] PRIMARY KEY CLUSTERED ([divisionID]) ON [PRIMARY]
GO