[Tzdb].[Zones]

BUILD09 > MoversSuite2 > Tables > Tzdb.Zones

Properties
Columns
Indexes
SQL Script
Uses
Used By

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count (~)	593
Created	9:10:38 AM Friday, November 8, 2024
Last Modified	9:10:50 AM Friday, November 8, 2024

Columns

	Name	Data Type	Max Length (Bytes)	Allow Nulls	Identity
	Id	int	4		1 - 1
	Name	varchar(50)	50

Indexes

	Name	Columns	Unique
	PK_Zones	Id
	IX_Zones_Name	Name

SQL Script

CREATE TABLE [Tzdb].[Zones]
(
[Id] [int] NOT NULL IDENTITY(1, 1),
[Name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [Tzdb].[Zones] ADD CONSTRAINT [PK_Zones] PRIMARY KEY NONCLUSTERED ([Id]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_Zones_Name] ON [Tzdb].[Zones] ([Name]) ON [PRIMARY]
GO

Uses

Tzdb

Used By

[Tzdb].[Intervals]
[Tzdb].[Links]
[Tzdb].[Links]