该语句可以简写成:IF EXISTS (SELECT name FROM sysobjects WHERE name = [Reservations] AND type = 'U') drop table [Reservations][Reservations]可以换成任何表名来判断其是否存在 这句话错了,应该是: IF EXISTS (SELECT name FROM sysobjects WHERE name = 'Reservations' AND type = 'U') drop table [Reservations]
WHERE name = [Reservations] AND type = 'U')
drop table [Reservations][Reservations]可以换成任何表名来判断其是否存在
为什么要开始就把所有表都删了了?
因为准备创建一个同名的表。如果不删除它,创建的时候会出错。
WHERE name = [Reservations] AND type = 'U')
drop table [Reservations][Reservations]可以换成任何表名来判断其是否存在
这句话错了,应该是:
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'Reservations' AND type = 'U')
drop table [Reservations]