Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2487
  • Last Modified:

What are all the types in sysobjects in syabase


I am new to sybase development. Wish to know what are the various type in sysobjects. Pls confirm whether the following are correct. Also any other code for type.

D  Default
F  FOREIGN KEY constraint
K  PRIMARY KEY or UNIQUE constraint
L  Log
P  Stored procedure
R  Rule
RF Stored procedure for
S  System table
TR Trigger
U  User table
V  View
Also what is the difference between type T and TR.

Pls guide!

1 Solution
From the ASE Reference

D = default
L = log
P = procedure
PR = prepare objects (created by Dynamic SQL)
R = rule
RI = referential constraint
S = system table
TR = trigger
U = user table
V = view
XP = extended stored procedure

Also in tempdb ( and tempdb only ) it includes temporary objects

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now