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.