Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Tables, views, and indexes

 

Viewing a list of system objects (SQL)

Query the SYSOBJECT system view to display information about system objects including system tables, system views, stored procedures, and domains.

Prérequis

There are no prerequisites for this task.

Contexte et remarques

You perform this task when you want see the list of system objects in the database, and their definitions, or when you want to use their definition to create other similar objects.

 Task
  1. In Interactive SQL, connect to a database.

  2. Execute a SELECT statement, querying the SYSOBJECT system view for a list of objects.

Résultat

The list of system objects displays in Interactive SQL.

Exemple

The following SELECT statement queries the SYSOBJECT system view, and returns the list of all tables and views owned by SYS and dbo. A join is made to the SYSTAB system view to return the object name, and SYSUSER system view to return the owner name.



SELECT b.table_name "Object Name", 
      c.user_name "Owner", 
      b.object_id "ID", 
      a.object_type "Type", 
      a.status "Status"
  FROM ( SYSOBJECT a JOIN SYSTAB b 
         ON a.object_id = b.object_id ) 
  JOIN SYSUSER c
WHERE c.user_name = 'SYS' 
   OR c.user_name = 'dbo'
ORDER BY c.user_name, b.table_name;

 See also