The Varigence company brand logo
Products
BimlFlexBimlStudioBimlExpress
Pricing
Solutions
IndustriesUse Cases
Resources
DocumentationKnowledge BaseBlog
About
CompanyContact Us
Products
BimlFlexBimlStudioBimlExpress
Pricing
Solutions
IndustriesUse Cases
Resources
DocumentationKnowledge BaseBlog
About
CompanyContact Us
Schedule Demo
Account
Schedule Demo
Account

Columns

<Biml xmlns="http://schemas.varigence.com/biml.xsd">
    <Tables>
        <Table Name="SampleTable" ConnectionName="TableConnection">
            <Columns>
                <Column Name="Simple" DataType="Int32" />
                <Column Name="IdentityColumn" DataType="Int64" IdentityIncrement="1" IdentitySeed="2" />
                <Column Name="String" DataType="String" Length="255" />
                <Column Name="DefaultValueColumn" DataType="Int32" Default="-1" />
                <Column Name="NotNull" DataType="Int32" IsNullable="false" />

                <!-- A Length of -1 will automatically be converted to nvarchar(max)/varchar(max) -->
                <Column Name="LongString" DataType="String" Length="-1" />

                <Column Name="Decimal" DataType="Decimal" Precision="5" Scale="1" />
                <!-- Computed columns - enter the TSQL expression you would normally enter after the "AS" statement -->
                <Column Name="ComputedColumn" Computed="[Simple]*2" DataType="Int32"/>

                <!-- For Custom Types, supply the best guess for the data type, length, precision, and scale.
                        Additionally set the custom SQL Server type. 
                        We use the DataType information as a guess when generating OLAP Cubes and other metadata.
                    -->
                <Column Name="Custom" DataType="Binary" Length="8" CustomType="rowversion" />

            </Columns>
        </Table>
    </Tables>
</Biml>

© Varigence