Hello all. I want to know whether it is possible to retrieve list of all tables found in a particular database titled 'Company'? It have got several tables with the names, Suppliers, Customers, etc etc. Just like Oracle, where you retrive all tables using select * from tab; . Is it possible to do the same in MS SQL???
There are a couple of ways to do it, depending on what version of SQL Server you are using and how detailed you need to get. First, in your query tool of choice (usually Management Studio) point to the database you're interested in, then use one of these:
--for SQL2000 or later, you can use either:
select * from sysobjects where type = 'U'
select * from INFORMATION_SCHEMA.TABLES
--for SQL2005 or later, you can also use this:
select * from sys.tables