CREATE TABLE [Asset_Device] (
  [DeviceGuid] uniqueidentifier NOT NULL
, [TimeLastAssetScan] datetime NOT NULL
, [DateCreated] datetime NOT NULL
, [DateModified] datetime NOT NULL
, [OMRowVersion] rowversion NOT NULL
);
GO
ALTER TABLE [Asset_Device] ADD CONSTRAINT [Asset_Device_DeviceGuid_PK] PRIMARY KEY ([DeviceGuid]);
GO
DROP TABLE [Asset_SMBios_MemoryDevice];
GO