Listing 1 VBScript

<%
' MyMeta is an intrinsic object available to all templates
Dim objCol
Dim objTable
Set objTable = MyMeta.Databases("Northwind").Tables("Employees")

For Each objCol in objTable.Columns
    output.writeLn(objCol.Name + " : " + objCol.LanguageType + " : " + objCol.DbTargetType)
Next
%>

The resulting output would be:

EmployeeID : int : SqlDbType.Int
LastName : string : SqlDbType.NVarChar
FirstName : string : SqlDbType.NVarChar
Title : string : SqlDbType.NVarChar
TitleOfCourtesy : string : SqlDbType.NVarChar
BirthDate : DateTime : SqlDbType.DateTime
HireDate : DateTime : SqlDbType.DateTime
Address : string : SqlDbType.NVarChar
City : string : SqlDbType.NVarChar
Region : string : SqlDbType.NVarChar
PostalCode : string : SqlDbType.NVarChar
Country : string : SqlDbType.NVarChar
HomePhone : string : SqlDbType.NVarChar
Extension : string : SqlDbType.NVarChar
Photo : byte[] : SqlDbType.Image
Notes : string : SqlDbType.NText
ReportsTo : int : SqlDbType.Int
PhotoPath : string : SqlDbType.NVarChar