Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
user db space
- Thread starter dupa12345
- Start date
hi dupa12345,
select
*
from
dbc.tables
where
databasename = 'db1'
the above will give you all tables/macros/views under ur database name....
if u wanna check the space occupied by ur database try this one below..
select
*
from
dbc.diskspace
where
databasename = 'db1'
regards
sridharan
select
*
from
dbc.tables
where
databasename = 'db1'
the above will give you all tables/macros/views under ur database name....
if u wanna check the space occupied by ur database try this one below..
select
*
from
dbc.diskspace
where
databasename = 'db1'
regards
sridharan
Hi,
you can simply do
help database db1;
to see what is created in your database space.
Views and Macros don't take away from your Diskspace allotment as they only reside inside the dictionary table.
Tables occupy space. Even a table which contains no rows will occupy 1K for every amp on your system due to the internal table header.
Stored procedures occupy space.
Every Index you create on your tables will use space if the table has rows.
As stated above in the other post you can see how much space each table is using by doing.....
select
*
from
dbc.diskspace
where
databasename = 'db1'
This is the total for the whole table, including the Primrary data table and fall back data table and index tables.
you can simply do
help database db1;
to see what is created in your database space.
Views and Macros don't take away from your Diskspace allotment as they only reside inside the dictionary table.
Tables occupy space. Even a table which contains no rows will occupy 1K for every amp on your system due to the internal table header.
Stored procedures occupy space.
Every Index you create on your tables will use space if the table has rows.
As stated above in the other post you can see how much space each table is using by doing.....
select
*
from
dbc.diskspace
where
databasename = 'db1'
This is the total for the whole table, including the Primrary data table and fall back data table and index tables.
- Status
Similar threads
