Seagate ST43401N/ND Installation Guide download pdf (Page 32)

Adaptive Server Objects

Query Sybase System Tables

The following system tables contain object information that you can use to

create installation scripts:

• sysdatabases

•

sysdevices

• sysusages

• sysobjects

• sysusers

• sysservers

• syslogins

• sysremotelogins

See the

System Administration Guide at

http://manuals.sybase.com:80/onlinebooks/group-

as/asg1250e/sag/@Generic__BookView

for more details on system tables and

objects. See also

Segment Remapping with load database When Moving a

Database at http://my.sybase.com/detail?id=1324

in Technical Information

Library for information on using system tables to reconstruct databases.

Use System Stored Procedures

For information about current ASE configuration, use sp_configure with no

argument. It will list all configuration parameters and their values.

For the SQL commands in a stored procedure, use sp_helptext.

See the

Reference Manual at http://manuals.sybase.com:80/onlinebooks/group-

as/asg1250e/refman/@Generic__BookView

for other system stored procedures

such as

sp_helpdevice, sp_help, sp_helpdb, sp_helpsegment and sp_helpindex

that can provide information about objects on your server.

Use Sybase Tools

You can reverse engineer server objects using Sybase DBA tools such as

Sybase Central, or Powersoft PowerDesigner, or use third-party tools.

1 2 ... 27 28 29 30 31 32 33 34 35 36 37 ... 145 146

No comments

Seagate ST43401N/ND Installation Guide Page 32