Table properties using SQL in Pervasive SQL control centre

Question

I wanted to retrieve table properties using pervasive sql control center. Version 9.52

How can i retrieve all the tables properties from a Database ? i tried some thing like below for one table but it throwed me an error

select * from "TABLE NAME"
CALL psp_column_attributes (, ,)

error messgae :- Invalid procedure name

Answer 1

It's possible you're installation doesn't have the system stored procedures. You should be able to recreate them. There should be a directory called restore under the system database directory. I can't remember where is was in V9, maybe c:\pvsw\demodata\system. I know that for v10 (and later), it is in C:\ProgramData\Pervasive Software\PSQL\system\restore or C:\ProgramData\Actian\PSQL\system\restore.