-- Herewith I am supplying some sample script and data:-

-- Using 1st database

USE NorthWind

GO

IF Object_id('Northwind..TableA') IS NOT NULL

BEGIN

DROP TABLE tableA

END

--Creating table

Create Table TableA

(

MyId uniqueidentifier,

DatabaseName varchar(500),

)

--Inserting dome sample...