sqlschemaowner

Why is it important to have schema or owner for a table when we can directly use the table itself


I have seen various schema and tables under them.

What is the significance of using schema or owner name with Tables rather than tables only.


Solution

  • schema definition is quite different in different database systems.

    but generally schema is used to categorize & organize some interrelated database objects, such as tables, Stored procedures , etc.

    here are some application/advantage of using schema: