createtable.sql

来自「免SQL Server客户端」· SQL 代码 · 共 20 行

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[A]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[A]
GO

CREATE TABLE [dbo].[A] (
	[A1] [int] IDENTITY (1, 1) NOT NULL ,
	[A2] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[A3] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[A] WITH NOCHECK ADD 
	CONSTRAINT [PK_A] PRIMARY KEY  CLUSTERED 
	(
		[A1]
	)  ON [PRIMARY] 
GO