Solved

table definition

Posted on 2006-11-28
1
1,037 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
ED710 -->  UADDMBX 10 287
PDF TO PCL format conversion on AS400 - infoprint server 4 89
Create AS400 Logical File 5 90
BRMS - TSM API DSMERROR.LOG 5 45
If you are looking at this article, you have most likely been hit by some version of ransomware and are trying to find out if there is anything you can do, or what way you should react - READ ON!
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

856 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