How to get the list of tables in Sybase?

Questions by christia   answers by christia

Editorial / Best Answer

rlbafna  

  • Member Since Mar-2008 | Mar 12th, 2008

sp_help - lists all objects (including tables and views)
List if Views : select name from sysobjects where type = "V"

Showing Answers 1 - 2 of 2 Answers

keerthv

  • Apr 21st, 2007
 

Select name from sysobjects where type="U"

This gives the list of user defined tables in the current database.

rlbafna

  • Mar 12th, 2008
 

sp_help - lists all objects (including tables and views)

List if Views : select name from sysobjects where type = "V"

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions