not-- match the ID value of the object in the specified database.CREATEDATABASETest; GOUSETest; GOCREATESCHEMAPerson; GOCREATETablePerson.Address(c1int); GOUSEAdventureWorks2022; GOSELECT*FROMsys.dm_db_index_physical_stats (DB_ID(N'Test'), OBJECT_ID(N'Person.Address'),NULL,NULL,'...
-- An error is returned because the ID value returned by OBJECT_ID does not -- match the ID value of the object in the specified database. CREATE DATABASE Test; GO USE Test; GO CREATE SCHEMA Person; GO CREATE Table Person.Address(c1 int); GO USE Advent...