【文件属性】:
文件名称:参考其它用户的表-SQL语言基础
文件大小:5.26MB
文件格式:PPT
更新时间:2021-04-25 19:38:27
SQL 基础
参考其它用户的表
*
其它用户的表并不在本用户的模式(模式)之中
要使用,则必须在其它表名前面加上前缀.
*
Referencing Another User’s Tables
A schema is a collection of objects. Schema objects are the logical structures that directly refer to the data in a database. Schema objects include tables, views, synonyms, sequences, stored procedures, indexes, clusters, and database links.
If a table does not belong to the user, the owner’s name must be prefixed to the table.