Tables [dbo].[tng_locale_info]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
HeapYes
Row Count0
Created11:07:35 AM Wednesday, March 07, 2007
Last Modified5:36:59 PM Monday, May 04, 2009
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Indexes baseidx_tng_locale_info: key_name\property_name\localeproperty_namechar(30)30
Yes
Indexes baseidx_tng_locale_info: key_name\property_name\localekey_namevarchar(128)128
Yes
locale_namenvarchar(512)1024
Yes
Indexes baseidx_tng_locale_info: key_name\property_name\localelocalechar(10)10
Yes
Indexes Indexes
NameColumnsUnique
baseidx_tng_locale_infokey_name, property_name, locale
Yes
Permissions
TypeActionOwning Principal
GrantDeleteuniadmin
GrantInsertuniadmin
GrantDeletewvadmin
GrantInsertwvadmin
GrantSelectuniadmin
GrantUpdateuniadmin
GrantSelectuniuser
GrantSelectwvadmin
GrantUpdatewvadmin
GrantSelectwvuser
SQL Script
CREATE TABLE [dbo].[tng_locale_info]
(
[property_name] [char] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[key_name] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[locale_name] [nvarchar] (512) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[locale] [char] (10) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_tng_locale_info] ON [dbo].[tng_locale_info] ([key_name], [property_name], [locale]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[tng_locale_info] TO [uniadmin]
GRANT INSERT ON  [dbo].[tng_locale_info] TO [uniadmin]
GRANT DELETE ON  [dbo].[tng_locale_info] TO [uniadmin]
GRANT UPDATE ON  [dbo].[tng_locale_info] TO [uniadmin]
GRANT SELECT ON  [dbo].[tng_locale_info] TO [uniuser]
GRANT SELECT ON  [dbo].[tng_locale_info] TO [wvadmin]
GRANT INSERT ON  [dbo].[tng_locale_info] TO [wvadmin]
GRANT DELETE ON  [dbo].[tng_locale_info] TO [wvadmin]
GRANT UPDATE ON  [dbo].[tng_locale_info] TO [wvadmin]
GRANT SELECT ON  [dbo].[tng_locale_info] TO [wvuser]
GO
Uses
Used By