Sql Statement to know Data Size

[RemingtonSteel]

Hello!

Can somebody help me get a SQL statement to get the size of a table and the whole database? I am using SQL 2005.

Thanks.
Gene

 

[mmerlinn]

You should post this question in a different forum. SQL here is specific to FoxPro and the solution for FP may be different than the solution you need.

mmerlinn

http://mmerlinn.com

"We've found by experience that people who are careless and sloppy writers are usually also careless and sloppy at thinking and coding. Answering questions for careless and sloppy thinkers is not rewarding." - Eric Steven Raymond

 

[markros]

I found

http://www.mssqlcity.com/Articles/KnowHow/RowCount.htm

 

[Zografski]

Take a look at

http://www.mssqltips.com/tip.asp?tip=1629

 

[Mike Lewis]

Gene,

The answer depends on which database back-end you are using. In most cases, the information you are looking for can be obtained from metadata (something like sysobjects in SQL Server, for example). But the details vary with the back-end.

So, in addition to Mmerlinn's point about it not being a VFP question, you really need to post it in a forum for your specific back end.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk