Tables [dbo].[pd_cluster_ext]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
HeapYes
Row Count0
Created12:31:08 PM Sunday, December 05, 2010
Last Modified12:31:08 PM Sunday, December 05, 2010
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
Indexes baseidx_pd_cluster_ext: machine_idmachine_idint4
No
cluster_aliasnvarchar(30)60
No
(' ')
cluster_typenvarchar(30)60
No
(' ')
Indexes Indexes
NameColumnsUnique
baseidx_pd_cluster_extmachine_id
Yes
Permissions
TypeActionOwning Principal
GrantDeletepdadmin
GrantInsertpdadmin
GrantDeleteuniadmin
GrantInsertuniadmin
GrantSelectpdadmin
GrantUpdatepdadmin
GrantSelectpduser
GrantSelectuniadmin
GrantUpdateuniadmin
SQL Script
CREATE TABLE [dbo].[pd_cluster_ext]
(
[machine_id] [int] NOT NULL,
[cluster_alias] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL CONSTRAINT [DF__pd_cluste__clust__23B427BF] DEFAULT (' '),
[cluster_type] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL CONSTRAINT [DF__pd_cluste__clust__24A84BF8] DEFAULT (' ')
) ON [PRIMARY]

GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_pd_cluster_ext] ON [dbo].[pd_cluster_ext] ([machine_id]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[pd_cluster_ext] TO [pdadmin]
GRANT INSERT ON  [dbo].[pd_cluster_ext] TO [pdadmin]
GRANT DELETE ON  [dbo].[pd_cluster_ext] TO [pdadmin]
GRANT UPDATE ON  [dbo].[pd_cluster_ext] TO [pdadmin]
GRANT SELECT ON  [dbo].[pd_cluster_ext] TO [pduser]
GRANT SELECT ON  [dbo].[pd_cluster_ext] TO [uniadmin]
GRANT INSERT ON  [dbo].[pd_cluster_ext] TO [uniadmin]
GRANT DELETE ON  [dbo].[pd_cluster_ext] TO [uniadmin]
GRANT UPDATE ON  [dbo].[pd_cluster_ext] TO [uniadmin]
GO
Uses