Interview Question in SQL Server Clustering
Interview Question :: Does anne know how to translate this into MS ACCESS
Object: Table [dbo].[subscribers] Script Date: 5/22/2006 8:26:43 AM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[subscribers]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[subscribers]
GO
/****** Object: Table [dbo].[subscribers] Script Date: 5/22/2006 8:26:43 AM ******/
CREATE TABLE [dbo].[subscribers] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[email] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[token] [nvarchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[subscribers] WITH NOCHECK ADD
CONSTRAINT [PK_subscribers] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
GO
Loading ...