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
Hi, I am a newbie in developing a website. i have tried to connect using mysqli conncetion
Here is my simple code.
// db.php code
//$con = mysqli_connect("localhost","root","","bakery"); ...
If you're in one of those predicaments where cls.__private attributes just aren't enough since they can easily be accessed through inst._cls__private, and you need something a little more secure, here's ...