Get MSSQL field flags with PHP

[sandoba]

Hello,

I'm currently developing a new database abstraction script. But there are some problems with MSSQL and field flags. How is it possible to get all the information about a field flag (like in MYSQL, e.g. "not_null primary_key auto_increment...")?

And my second question: Is it possible to list all the user defined databases?

Thank you for your answers!

[vass0922]

You maybe able to do a query in query analyzer

select * from sysobjects where xtype = 'U'
make sure to do the query on the master database.

not sure how to get the flags off hand though.
You could simply set them so you KNOW what it is?

Welcome to TechIMO

[sandoba]

Of course I could, but my cms has a database tool like phpmyadmin but not only for mysql. Users should also be able to set flags and thats why I need to get and show them at first (without access to the master db because of shared hosting).

[Praetorian]

Hmm....is MSSQL somewhat like MySQL? In MySQL you just do explain table or describe table.

[sandoba]

I tried with mssql enterprise manager, but it wasn't possible. If you know any websites/forums for db professionals, please tell me where to find these. Thanks.

[qball]

How is it possible to get all the information about a field flag (like in MYSQL, e.g. "not_null primary_key auto_increment...")

flag? more like column property/attribute. This info is found in the DB schema.

I tried with mssql enterprise manager, but it wasn't possible.

Then you aren't using that tool properly, as any DB enterprise manger will provide that info, ways to manage,etc, else NOT 'enterprise manager'.

can you use, 'mssql enterprise manager' to execute SQL statement?

[Creosote]

Look up "sp_describe_cursor_columns" in SQL Server Books Online. That stored procedure should give you the information you need.