IF OBJECT_ID(N'[dbo].[FixedDriveInformation]', N'U') IS NULL
	BEGIN
		
		CREATE TABLE dbo.FixedDriveInformation
		(
			Id INT IDENTITY(1,1) NOT NULL
			,ServerInstance VARCHAR(100) NOT NULL
			,DriveLetter CHAR(1) NOT NULL
			,DriveLabel VARCHAR(50) NOT NULL
			,GBFreeSpace NUMERIC(2,2) NOT NULL
			,DriveSize NUMERIC(2,2) NOT NULL
			CONSTRAINT [FixedDriveInformation_Id] PRIMARY KEY CLUSTERED (Id)
		)
			
		IF OBJECT_ID(N'[dbo].[FixedDriveInformation]', N'U') IS NOT NULL
			BEGIN
			
				PRINT 'SUCCESS - Table [dbo].[FixedDriveInformation] created.'
				
			END
		ELSE
			BEGIN
			
				RAISERROR('FAIL - Table [dbo].[FixedDriveInformation] not created.',16,1)
				
			END

	END
ELSE
	BEGIN
	
		PRINT 'EXISTS - Table [dbo].[FixedDriveInformation] already exists.'
		
	END

GO