Tables [dbo].[pd_cluster_ext]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
HeapYes
Row Count0
Created11:07:24 AM Wednesday, March 07, 2007
Last Modified11:09:41 AM Wednesday, March 07, 2007
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