![](https://cos-cdn.shuashuati.com/pipixue-wap/2020-1230-1107-56/ti_inject-812ce.png)
USE BookShop Go IF EXISTS (SELECT * FROM SYSOBJECTS WHERE NAME='Member') DROP TABLE Member CREATE TABLE Member (User_ID int PRIMARY KEY NOT NULL, User_Name varchar (50) NOT NULL, User_Sex char (2) NOT NULL, User_Pass varchar (20) NOT NULL, User_TrueName varchar (20) NOT NULL, User_Address varchar(50) NOT NULL, User_Telephone varchar (15) NOT NULL, User_Postcode varchar (6) NOT NULL, User_Email varchar (20) , User_Credit Numeric (18,0) NOT NULL, User_Demo ntext ) 上述语句: IF EXISTS (SELECT * FROM SYSOBJECTS WHERE NAME='Member') DROP TABLE Member 的作用是解决二次创建一个已经存在的表,系统不允许创建的问题。