Keys and indexes

[BB101]

I am trying to create a database administratation program and have achieved quite a lot... however, I still need the ability to show what the keys and indexes (and other properties) are... can anyone help??

Cheers

--BB

 

[vcherubini]

Have you ever heard of phpMyAdmin? It is probably the most well known mysql database administration tool out there, done in PHP.

You can download it at

http://www.phpwizard.net.

What kind of properties are you looking for?

For example, you can use this function to get the datatype of each field:

[tt]
string mysql_field_flags (resource result, int field_offset)
[/tt]

You could use a query like "SHOW COLUMNS FROM TableName" to get the default values of a field.

Is this helping?

What are your specific questions?

Hope this helsp.

-Vic vic cherubini
krs-one@cnunited.com

http://www.cnunited.com

====
Knows: Perl, HTML, JavScript, C/C++, PHP, Flash
====

 

[BB101]

im using MSSQL 2K... i need to know field properties like index's, uniqueness, etc... the basics

 

[BB101]

I am trying to write a Database administration program for an MSSQL 2K serve... Updating the table without knowing what the keys are is very difficult (as its ment to be completely dynamic)...

I am really in need of help here!