適用於: 是SQL Server 否Azure SQL Database 否Azure SQL 資料倉儲 否平行處理資料倉儲 APPLIES TO: yesSQL Server noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse


產品名稱Product Name SQL ServerSQL Server
事件識別碼Event ID 25012501
元件Component SQLEngineSQLEngine
訊息文字Message Text 找不到名為 'NAME' 的資料表或物件。Cannot find a table or object with the name 'NAME'. 請檢查系統目錄。Check the system catalog.


找不到指定的物件。The specified object cannot be found.

可能的原因Possible Causes

這項錯誤可能是由於下列其中一個問題所造成:This error can be caused by one of the following problems:

  • 未正確地指定物件。The object is not specified correctly.

  • 物件不存在,或是在陳述式嘗試使用之前已經卸除物件。The object does not exist, or the object was dropped before a statement tried to use it.

  • 物件可能存在,但是無法向使用者顯示物件。The object might exist, but could not be exposed to the user. 例如,使用者可能沒有物件的權限,或是物件是使用者看不到的內部資料表。For example, the user might not have permissions on the object, or the object is an internal table that could not be seen by a user.

使用者動作User Action

  • 確認目前的資料庫內容是否正確。Verify the current database context is correct. 如需詳細資訊,請參閱 USE (Transact-SQL)For more information, see USE (Transact-SQL).

  • 確認資料表或物件名稱拚字是否正確。Verify that the table or object name is spelled correctly.

  • 驗證包含物件的結構描述名稱。Verify the schema name that contains the object. 如果物件所屬的結構描述不是預設的結構描述 (dbo),您就必須使用 schema_name.object_name 的兩部分格式來指定資料表或物件名稱。If the object belongs to a schema other than the default (dbo) schema, you must specify the table or object name by using the two-part format schema_name.object_name.

  • 確認物件是否存在系統資料表中。Verify that the object exists in the system tables. 若要確認資料表或其他結構描述範圍物件是否存在,請查詢 sys.objects 目錄檢視。To verify whether a table or other schema-scoped object exists, query the sys.objects catalog view. 如果物件不在系統資料表中,表示物件已經刪除,或是使用者沒有檢視物件中繼資料的權限。If the object is not in the system tables, the object has been deleted, or the user does not have permissions to view the object metadata. 如需如何檢視物件中繼資料的詳細資訊,請參閱中繼資料可見性組態For more information about how to view object metadata, see Metadata Visibility Configuration.

另請參閱See Also

目錄檢視 (Transact-SQL)Catalog Views (Transact-SQL)