Lo que hice fue poner lo siguiente al inicio del script sql:
Código
USE master GO IF EXISTS (SELECT * FROM sysdatabases WHERE name='mapeo1') DROP DATABASE mapeo1 GO CREATE DATABASE mapeo1 GO CREATE TABLE EMP( ... . .
Pero parece que no está funcionando, porque me da el siguiente error:
Citar
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'EMP' in the database.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'DEP' in the database.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'COURSE' in the database.
Msg 2714, Level 16, State 4, Line 2
There is already an object named 'EMP' in the database.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'DEP' in the database.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'COURSE' in the database.
Msg 2714, Level 16, State 4, Line 2
Aunque no me da ese error con la última tabla que cree que se llama TAKES. ¿Qué hay malo?