"DROP TABLE" is what you would need to look for, in the scripts you ran, in order to figure which tables were killed.
I never did understand why there would ever be a DROP TABLE statement in a modules' SQL install scripts.
Personally I prefer table creation blocks structured like this:
IF NOT EXISTS (SELECT * FROM {databaseOwner}SYSOBJECTS WHERE id = object_id(N'{databaseOwner}[{objectQualifier}AdverExpContentTypes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE {databaseOwner}[{objectQualifier}AdverExpContentTypes] (
[ID] int IDENTITY ( 1,1 ) NOT NULL,
[Extension] nvarchar(50) NULL,
[ContentType] nvarchar(100) NULL
)
ALTER TABLE {databaseOwner}[{objectQualifier}AdverExpContentTypes] WITH NOCHECK ADD
CONSTRAINT [{objectQualifier}PK_AdverExpContentTypes] PRIMARY KEY CLUSTERED
(
[ID]
) ON [PRIMARY]
END
GO