?
Solved

table definition

Posted on 2006-11-28
1
Medium Priority
?
1,043 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
[X]
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
 
LVL 18

Accepted Solution

by:
Dave Ford earned 1000 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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

In the absence of a fully-fledged GPO Management product like AGPM, the script in this article will provide you with a simple way to watch the domain (or a select OU) for GPOs changes and automatically take backups when policies are added, removed o…
If you're a modern-day technology professional, you may be wondering if certifications are really necessary. They are. Here's why.
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses
Course of the Month11 days, 6 hours left to enroll

752 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