Tables [dbo].[si_pri_prop]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count6
Created6:13:22 PM Tuesday, May 05, 2009
Last Modified6:13:22 PM Tuesday, May 05, 2009
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK_si_pri_prop: enum\data_sourceenumint4
No
Cluster Primary Key PK_si_pri_prop: enum\data_sourcedata_sourcenvarchar(128)256
No
namenvarchar(12)24
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_si_pri_prop: enum\data_sourcePK_si_pri_propenum, data_source
Yes
Permissions
TypeActionOwning Principal
GrantInsertaiadmin
GrantDeletesiadmins
GrantInsertsiadmins
GrantDeleteaiadmin
GrantReferencesaiadmin
GrantSelectaiadmin
GrantUpdateaiadmin
GrantSelectaipublic
GrantReferencessiadmins
GrantSelectsiadmins
GrantUpdatesiadmins
SQL Script
CREATE TABLE [dbo].[si_pri_prop]
(
[enum] [int] NOT NULL,
[data_source] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[name] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[si_pri_prop] ADD CONSTRAINT [PK_si_pri_prop] PRIMARY KEY CLUSTERED ([enum], [data_source]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[si_pri_prop] TO [aiadmin]
GRANT SELECT ON  [dbo].[si_pri_prop] TO [aiadmin]
GRANT INSERT ON  [dbo].[si_pri_prop] TO [aiadmin]
GRANT DELETE ON  [dbo].[si_pri_prop] TO [aiadmin]
GRANT UPDATE ON  [dbo].[si_pri_prop] TO [aiadmin]
GRANT SELECT ON  [dbo].[si_pri_prop] TO [aipublic]
GRANT REFERENCES ON  [dbo].[si_pri_prop] TO [siadmins]
GRANT SELECT ON  [dbo].[si_pri_prop] TO [siadmins]
GRANT INSERT ON  [dbo].[si_pri_prop] TO [siadmins]
GRANT DELETE ON  [dbo].[si_pri_prop] TO [siadmins]
GRANT UPDATE ON  [dbo].[si_pri_prop] TO [siadmins]
GO
Uses