Tables [dbo].[das_recmndtext]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
Row Count0
Created11:07:11 AM Wednesday, March 07, 2007
Last Modified11:09:08 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key pk_das_recmndtext: recmndidrecmndiddecimal(10,0)9
No
recmndcodevarchar(255)255
Yes
textidvarchar(255)255
Yes
textvaluevarchar(255)255
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key pk_das_recmndtext: recmndidpk_das_recmndtextrecmndid
Yes
Permissions
TypeActionOwning Principal
GrantDeleteudmadmin_group
GrantInsertudmadmin_group
GrantSelectudmadmin_group
GrantUpdateudmadmin_group
SQL Script
CREATE TABLE [dbo].[das_recmndtext]
(
[recmndid] [decimal] (10, 0) NOT NULL,
[recmndcode] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[textid] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[textvalue] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[das_recmndtext] ADD CONSTRAINT [pk_das_recmndtext] PRIMARY KEY CLUSTERED ([recmndid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[das_recmndtext] TO [udmadmin_group]
GRANT INSERT ON  [dbo].[das_recmndtext] TO [udmadmin_group]
GRANT DELETE ON  [dbo].[das_recmndtext] TO [udmadmin_group]
GRANT UPDATE ON  [dbo].[das_recmndtext] TO [udmadmin_group]
GO
Uses