How to get the name and descriptions of SAP B1 table and own fields from SQL Server?

[mucipilbuga]

Hi,

I can see tables and field desriptions in query generator. It must be written in the SQL Server.

I want to use this information in my PHP code. I can see all the tables with below SQL Statement;

SELECT name FROM SYSOBJECTS WHERE xtype = 'U' ORDER by name;

But I can not see the table definitions. I see some HTML tables from forums and other sites but I want to get all these names, definitions of table and fields from SQLServer.

Where can I find this information from SQLServer?

Regards,

Mucip:)