select * from SYSOBJECTS  where TYPE = 'U' order by NAME

equals to the one in mysql

show tables

Or we can use sp_help, for exmple:

exec sp_help database_name

refer to http://msdn.microsoft.com/en-us/library/aa933429.aspx

Tagged with:
 

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>