What are all the types in sysobjects in syabase

Posted on 2003-03-11
Medium Priority
Last Modified: 2012-06-27

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!

Question by:bijo_p_mathew
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment

Accepted Solution

walzkev earned 750 total points
ID: 8114095
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

Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Check out the latest tech news, community articles, and expert highlights in August's newsletter.
This month, Experts Exchange’s free Course of the Month is focused on CompTIA IT Fundamentals.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question