sp_helpdb doesn't return all columns

W开发者_运维百科hen I run sp_helpdb dbname in Sybase Adaptive Server Enterprise, it returns only the following columns:

name,db_size,owner,dbid,created,status

And it's not returning the following columns:

device_fragments,size,usage,created,free kbytes

Why is this happening?

Both sets are returned however where they are displayed depends on which tool you're using to run the query. If you're using SQL Advantage or ASEISQL, then you need to look in the results and the messages windows to get the full answers. If you're using the command line ISQL then all will be returned together.

It's because some of the results are returned from a select, and some from print messages.

print "Print hello"

select "Select hello"

Try running the above and you'll hopefully find where each different output is displayed in your tool.

If you're using SQL Advantage see the SQL Advantage image here, this shows the options screen in which you can change how your results return. The "Display Print Messages with Results" might help in this case.