Database Design

[JulietB]

Does anyone know how to find the maximum records per table in a database, or how to view the size of tables in a database.
I know that the max size when designing table is 1G and the database size is 2G, I need to know if it is possible to get the table properties (rows,size)and how.

Thanks for your help
Juliet

 

[pivan]

Gosh...in Oracle isn't it SELECT COUNT * FROM T_MYTABLE..this will return the number of rows in the table. In not now, when?
If not here, where?
If not us, who?

Just do it!!

 

[JulietB]

Thank you pivan, but that still does not answer my question.
From a designer's perspective, what are the specs for a database in regards to TABLE (MAX - records) or (MAX - size).

For a table that is already designed and has data, how do you view the size of that particular table(bytes,KB,MB,Gig).

Thanks again.
Juliet

 

[dbmsguy]

what dbms are you using? Paul

http://www.dbmsguy.com