Connecting Tech Pros Worldwide Help | Site Map
bytes > topic > mysql > answers

How to count objects in Database?

Newbie
  
Join Date: Dec 2007
Posts: 15
#1: Sep 9 '08
How to check number of objects present in the database?

(In sql ,we use sys.objects)

Similar to this in MySql.
Atli's Avatar
Moderator
  
Join Date: Nov 2006
Location: Iceland
Posts: 3,745
#2: Sep 9 '08

re: How to count objects in Database?

For the record, SQL is not just one specific database server. It is the name of the query language ;)
(Although Microsoft, being somewhat nearsighted, just named their server SQL Server.)

In MySQL, you can get a list of all tables in a database by using the SHOW TABLES command.
Reply

« previous question | next question »

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,327 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved