Table size in DB

Question

Table size in DB

Viewing 9 posts - 16 through 23 (of 23 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004412 More actions · Answer 1

Thanks, Sugesh...

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

LakshmiAlagappan Valued Member Points: 62 More actions · Answer 2

i'm new to this work environment but basically from IT side, completed my BE in 2006. can anyone help me out?

im using sql anywhere 10. and this doesnt support sp_spaceused.

can anyone give me a script to find the size of a purticular table in the DB with some basic explanation?

Thanks in advance

Jeff Moden SSC Guru Points: 1004412 More actions · Answer 3

Does it support the following query?

 SELECT * FROM SysIndexes

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

LakshmiAlagappan Valued Member Points: 62 More actions · Answer 4

getting error like tablename sysIndexes is ambiguous

LakshmiAlagappan Valued Member Points: 62 More actions · Answer 5

im using interactive SQl tool provided by SQL anywhere10

Jeff Moden SSC Guru Points: 1004412 More actions · Answer 6

Sorry... not familiar with either the tool or the product, Lakshmi.

Can anyone else help Lakshmi?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Sugesh Kumar One Orange Chip Points: 27311 More actions · Answer 7

SQL Anywhere is a SYBASE EDM. sp_spaceused is not support there and has been replaced. Read the link given below to know what has got changed in syabase.

http://www.ianywhere.com/developer/product_manuals/sqlanywhere/1000/en/pdf/dbwnen10.pdf

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com

LakshmiAlagappan Valued Member Points: 62 More actions · Answer 8

yes, i have that PDF. and i know that sp_spaceused is not supported anymore.

juz want to know sp_spaceused was replaced with? i mean an alternative for that. or any script that u can help me out with?

Michael Valentine Jones SSC Guru Points: 64818 More actions · Answer 9

You should post your question on a site wherer they answer SYBASE questions.

You might try the SYBASE forum on dbforumns.com