Schema_Name

 The name of the schema the table belongs to.

Supported By

SQL Drivers (SQL Server, DB2 and ODBC)

Value

The name of the schema the table belongs to. A schema is a collection of names or objects. A schema can contain tables, views, and triggers. Schemas provide a logical classification of objects in the database.

If the keyword is not set, the user ID used to login to the data source is used as the schema name.

Associated Attribute

DF_FILE_OWNER (String)

Remarks

The Schema_Name keyword was created and designed with SQL92 in mind. SQL Server has a completely different approach to security and privileges and uses owners.

See Also

Header Keywords