Tables [dbo].[building]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
HeapYes
Row Count0
Created11:07:04 AM Wednesday, March 07, 2007
Last Modified11:09:34 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
idint4
Yes
Indexes $build_u0000354000000000: screennamescreennamevarchar(32)32
No
descriptionvarchar(32)32
Yes
latitudefloat8
Yes
longitudefloat8
Yes
_3dresourceidint4
Yes
starttimedatetime8
Yes
endtimedatetime8
Yes
createdbyint4
Yes
Indexes Indexes
NameColumnsUnique
$build_u0000354000000000screenname
Yes
SQL Script
CREATE TABLE [dbo].[building]
(
[id] [int] NULL,
[screenname] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[description] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[latitude] [float] NULL,
[longitude] [float] NULL,
[_3dresourceid] [int] NULL,
[starttime] [datetime] NULL,
[endtime] [datetime] NULL,
[createdby] [int] NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [$build_u0000354000000000] ON [dbo].[building] ([screenname]) ON [PRIMARY]
GO
Uses
Used By