CREATETABLE[dbo].[ConsolidationDeviceInfo] ( [DeviceID][int]NOTNULL, [Date][datetime]NOTNULL )ON[PRIMARY] GO ALTERTABLE[dbo].[ConsolidationDeviceInfo]ADDCONSTRAINT[PK_ConsolidationDeviceInfo_DeviceID]PRIMARYKEYCLUSTERED([DeviceID])ON[PRIMARY] GO ALTERTABLE[dbo].[ConsolidationDeviceInfo]ADDCONSTRAINT[FK_ConsolidationDeviceInfo_DeviceID_Device_DeviceID]FOREIGNKEY([DeviceID])REFERENCES[dbo].[Device]([DeviceID])ONDELETECASCADE GO