how can I see the length of a table (in bytes) on SQL Anywhere? It s possible?
Thank you
To find the number of bytes taken up by the data in a table:
select db_property( pagesize )*(stab.table_page_count+stab.ext_page_count)
from sys.systab stab join sys.sysuser suser on stab.creator=suser.user_id
where stab.table_name= table_name and suser.user_name= user_name
This does not include the size of any indexes or triggers on the table.
I am migrating an existing set of applications from Win XP to Win 7. We have a 3rd party application which is launched by and runs in the user’s session which accesses a local SQL Anywhere 9 database ...
We are using Sybase SQL Anywhere 11. We need to encrypt some of our tables in our database. I followed the instruction and did it. We selected the "strong" option with encryptionKey and AES256_FIPS ...
I have a database which is part of a closed system and the end-user of the system would like me to write some reports using the data contains in a Sybase SQL Anywhere Database. The system doesn t ...
I develop am webservice based on apache tomcat 6.0.26, apache cxf 2.2.7, spring 3.0, hibernate 3.3 and sybase sqlanywhere 11. im using the latest JDBC Driver from SYBASE jconn.jar Version 6. The ...
I have a database file (*.db) that need to be recovered. The bad is, the end-user have null idea of the version of the database. Not know the password. The original developer is lost. The computer ...
I am trying to import data into my table using INPUT INTO The problem is my decimals is using , as a delimiter, and it expects .. So it won t work! How can i change this? Search and replace in the ...
I have a Sybase SQL Anywhere 11.0.1 database that I am using to sync with an Oracle Consolidated Database. I know that the SQL Anywhere database keeps track of all of the changes that are made to it ...
how can I see the length of a table (in bytes) on SQL Anywhere? It s possible? Thank you