How to get Schema of a table?

Posts   
 
    
netLearner
User
Posts: 150
Joined: 18-Oct-2003
# Posted on: 15-Dec-2004 18:16:40   

Hi Frans, Is there a way to get the schema of a table using pro? Thanks.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39933
Joined: 17-Aug-2003
# Posted on: 16-Dec-2004 09:43:00   

You mean, in SQL code? Sure, grab TemplateStudio from the extra's section and the new SDK, and write a template, all information is available to you in the Catalog in the project, so you should be able to write such a template in a couple of minutes (just use C# or VB.NET)

If you want to read the schema at runtime, that's not possible, you need a proc for that.

Frans Bouma | Lead developer LLBLGen Pro