在数据库test2中新建表FRUITS、SUPPLIERS,在新建之前,如果已经有同名的表存在则将其删除;
USE test2
GO
BEGIN TRY DROP TABLE FRUITS END TRY BEGIN CATCH END CATCH;
BEGIN TRY DROP TABLE SUPPLIERS END TRY BEGIN CATCH END CATCH;
CREATE TABLE FRUITS
(
f_id INT PRIMARY KEY,
f_name
在数据库test2中新建表FRUITS、SUPPLIERS,在新建之前,如果已经有同名的表存在则将其删除;
USE test2
GO
BEGIN TRY DROP TABLE FRUITS END TRY BEGIN CATCH END CATCH;
BEGIN TRY DROP TABLE SUPPLIERS END TRY BEGIN CATCH END CATCH;
CREATE TABLE FRUITS
(
f_id INT PRIMARY KEY,
f_name