Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Query Designer error
Message
From
14/12/1999 19:23:59
 
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00303712
Message ID:
00303770
Views:
21
Here's the script I got for one of the tables having a problem, when I generated scripts:

CREATE TABLE [dbo].[VMCustomer] (
[UserPin] [varchar] (20) NOT NULL ,
[Agent] [varchar] (20) NOT NULL ,
[PagePin] [varchar] (20) NULL ,
[RecordPWD] [varchar] (20) NULL ,
[RetrievePWD] [varchar] (20) NULL ,
[ServiceID] [int] NULL ,
[FlexRValue] [varchar] (5) NULL ,
[CapCode] [varchar] (14) NULL ,
[PagePrefix] [varchar] (8) NULL ,
[PagePostfix] [varchar] (8) NULL ,
[VMailPrefix] [varchar] (8) NULL ,
[NotifyNo] [varchar] (16) NULL ,
[NotifyPin] [varchar] (16) NULL ,
[NotifyType] [smallint] NULL ,
[RemoteID] [varchar] (16) NULL ,
[GreetingNo] [smallint] NULL ,
[Status] [smallint] NULL ,
[CreateTime] [datetime] NULL ,
[DisableTime] [datetime] NULL ,
[ModifyTime] [datetime] NULL ,
[SuspendTime] [datetime] NULL ,
[OverlimitTime] [datetime] NULL ,
[CallCount] [int] NULL ,
[PageCount] [int] NULL ,
[DialCount] [int] NULL ,
[FaxCount] [int] NULL ,
[EmailCount] [int] NULL ,
[VoicemailCount] [int] NULL ,
[ReservedCount1] [int] NULL ,
[ReservedCount2] [int] NULL ,
[ReservedCount3] [int] NULL
) ON [PRIMARY]
GO


ALTER TABLE [dbo].[VMCustomer] WITH NOCHECK ADD
CONSTRAINT [PK_VMCustomer] PRIMARY KEY NONCLUSTERED
(
[UserPin]
) ON [PRIMARY]
GO

Thanks,

PF

>Do the tables have declared PKs
>
>-Mike

(On an infant's shirt): Already smarter than Bush
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform