Tables [dbo].[NCPROFIL]
(local) > CAAMDB_EXAMPLE > Tables > dbo.NCPROFIL
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count36
Created3:44:39 PM Friday, June 13, 2003
Last Modified3:44:39 PM Friday, June 13, 2003
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Primary Key NCPROFIL_PK: PROFILIDPROFILIDint4
No
PROFILLNint4
Yes
PROFILTXvarchar(127)127
Yes
Indexes Indexes
NameColumnsUnique
Primary Key NCPROFIL_PK: PROFILIDNCPROFIL_PKPROFILID
Yes
SQL Script
CREATE TABLE [dbo].[NCPROFIL]
(
[PROFILID] [int] NOT NULL,
[PROFILLN] [int] NULL,
[PROFILTX] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[NCPROFIL] ADD CONSTRAINT [NCPROFIL_PK] PRIMARY KEY NONCLUSTERED ([PROFILID]) ON [PRIMARY]
GO
Uses
Created 03 June 2010 08:02
Copyright 2010 by CA Technologies, Inc. - All Rights Reserved