I am researching a problem in a sybase database and I need to know the table structure. I've gotten sp_tables to list the tables, but there are 383 of them and you can only scroll up to the last 20 or 30. How can I pipe the output or limit it so that I can see all of the tables? I am logged in using SSH and accessing the database using "isql -Uxxxx -Pxxxx". This is the only option I have for accessing the database.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Pipe or limit sp_tables output
- Thread starter nerbonne
- Start date
dbalearner
Technical User
To get a list of all tables in a given database do:
use <DATABASE>
go
select name from sysobjects where type = 'U' order by name
go
To see a structure of a table do
sp_help <TABLE_NAME>
go
etc
good luck
use <DATABASE>
go
select name from sysobjects where type = 'U' order by name
go
To see a structure of a table do
sp_help <TABLE_NAME>
go
etc
good luck
- Status
Similar threads
- Locked
- Question