Solved

table definition

Posted on 2006-11-28
1
1,035 Views
Last Modified: 2012-05-05
Hi

This is a noob question:
is there an equivalent of the sp_help sp in SQL that I can use on AS400? or anything like the sysobjects tables in SQL?
I am interested of a quick way of querying the table definitions from a query tool (like the SQL Scripts tool under ISeries navigator)

Cheers
Dani
0
Comment
Question by:daniel_balla
1 Comment
 
LVL 18

Accepted Solution

by:
daveslash earned 250 total points
ID: 18038313

SysTables holds high-level table information
SysColumns holds column-definition information for the tables
SysConstraints holds (as you would expect) constraint information'
SysRoutines holds info about stored procedures and functions

There are other SYS tables, but those are the one I use the most.

Alternately, if you have access to a command-line, you can use the old stand-by command DspFD.

HTH,
DaveSlash
0

Featured Post

ScreenConnect 6.0 Free Trial

Want empowering updates? You're in the right place! Discover new features in ScreenConnect 6.0, based on partner feedback, to keep you business operating smoothly and optimally (the way it should be). Explore all of the extras and enhancements for yourself!

Question has a verified solution.

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

If you thought ransomware was bad, think again! Doxware has the potential to be even more damaging.
Does your audience prefer people in photos or no people? How can you best highlight what you’re selling? What are your competitors doing, and what can you do that is different and unique from them?  Continue reading to learn how to make your images …
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

803 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