Tables [dbo].[ap_wmv_session_nm]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
HeapYes
Row Count0
Created11:06:59 AM Wednesday, March 07, 2007
Last Modified11:09:31 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Indexes baseidx_ap_wmv_session_nm: session_nm_idsession_nm_idint4
No
Indexes ap_wmv_session_nm_x1: session_nm\ap_hostsession_nmvarchar(16)16
No
Indexes ap_wmv_session_nm_x1: session_nm\ap_hostap_hostvarchar(16)16
No
Indexes Indexes
NameColumnsUnique
baseidx_ap_wmv_session_nmsession_nm_id
Yes
ap_wmv_session_nm_x1session_nm, ap_host
Permissions
TypeActionOwning Principal
GrantDeleteapwmv_admin
GrantInsertapwmv_admin
GrantSelectapwmv_admin
GrantUpdateapwmv_admin
GrantSelectapwmv_user
SQL Script
CREATE TABLE [dbo].[ap_wmv_session_nm]
(
[session_nm_id] [int] NOT NULL,
[session_nm] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[ap_host] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ap_wmv_session_nm_x1] ON [dbo].[ap_wmv_session_nm] ([session_nm], [ap_host]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_ap_wmv_session_nm] ON [dbo].[ap_wmv_session_nm] ([session_nm_id]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ap_wmv_session_nm] TO [apwmv_admin]
GRANT INSERT ON  [dbo].[ap_wmv_session_nm] TO [apwmv_admin]
GRANT DELETE ON  [dbo].[ap_wmv_session_nm] TO [apwmv_admin]
GRANT UPDATE ON  [dbo].[ap_wmv_session_nm] TO [apwmv_admin]
GRANT SELECT ON  [dbo].[ap_wmv_session_nm] TO [apwmv_user]
GO
Uses