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!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DBA Queries

Status
Not open for further replies.
trutta1

trutta1

IS-IT--Management
Apr 10, 2007
11
US
I am looking for a list of queries that query metadata information form a database ( Table size, Index names + base table, Size ( in Bytes) of rows stuff like that. There does not saeem to be allot written on the Pervasive database like Oracle or Sybase
 
Sort by date Sort by votes
You might look at the System Stored Procedures. That's about the only "DBA Queries" that I'm aware of.
What are you trying to accomplish?

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
 
Upvote 0 Downvote
What I am trying to do is asmiple database audit. Just showing the tables, views, indexes their column names , column sizes row lenghts... Stuff like that. I am just documenting the database without having to cut and past the DDL.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

PIlango
  • Locked
  • Question
Queries running 50% slower on Virtual Servers
Replies
1
Views
113
mirtheil
mirtheil
jrbade
  • Locked
  • Question
Invalid Precision Value For Dates in Update Queries
Replies
3
Views
88
jrbade
jrbade
dison123
  • Locked
  • Question
PSQL and Variables - How do I use them in queries? 1
Replies
2
Views
95
dison123
dison123
JordanCN
  • Locked
  • Question
Using Parameters for passthrough queries
Replies
0
Views
50
JordanCN
JordanCN
BOH2007
  • Locked
  • Question
Converting dBase fieldtypes logical and memo
Replies
2
Views
63
mirtheil
mirtheil

Part and Inventory Search

Sponsor

Back
Top