Listing 3

Script pour laisser tomber la base de données testdb_partial et recrée les deux tables

USE master
DROP DATABASE testdb_partial
GO
USE testdb
GO
DROP TABLE table1
GO
CREATE TABLE table1
(a int identity, b char(100) )
ON FG1
GO
INSERT INTO table1
SELECT ‘This is table1 in FG1'
GO
DROP

                    

TABLE table2
GO
CREATE TABLE table2
(a int identity, b char(100) )
ON FG2
GO
INSERT INTO table2
SELECT ‘This is table2 in FG2′
GO