How list out all tables in MS SQL?

[ailinseng]

hi,
In Oracle SQL command, if i want to list out all the tables in a database, i will use ' SELECT * FROM TABS".
But then for MS SQL, what command should I use?
Hope some expertise in sql can help me in this....
Thanks a lot in advance...

[bartonc]

hi,
In Oracle SQL command, if i want to list out all the tables in a database, i will use ' SELECT * FROM TABS".
But then for MS SQL, what command should I use?
Hope some expertise in sql can help me in this....
Thanks a lot in advance...

Not sure; let's ask in the MS SQL Forum, shall we...[from Member Introducutions]

[iburyak]

Try this:

[PHP]Select name from sysobjects where type like 'u'[/PHP]

type like 'u' - means user_table.


Good Luck.

[KentBill]

SELECT sys.sysobjects.name AS tname
FROM sys.sysobjects LEFT OUTER JOIN
sys.sysusers ON sys.sysobjects.uid = sys.sysusers.uid
WHERE (sys.sysobjects.type = 'U')

[Doranj00]

Hi,

I am also coming from an Oracle background and found this page really useful;


http://vyaskn.tripod.com/oracle_sql_server_differences_equivalents.htm

It lists out the equivalent SQL commands/code etc and also has articke for works arounds when there is no equivalent.

Good luck, hope it helps!

Hannah