<div>
You execute a SQL statement such as this for MS SQL Server for example:<br />
(<a href="http://msdn.microsoft.com/en-us/library/aa275462(SQL.80).aspx" rel="ugc nofollow">http://msdn.microsoft.com/en-us/library/aa275462(SQL.80).aspx</a>)<br />

<pre><code id="code-361938">ALTER TABLE your_table_name
ADD COLUMN column_name {datatype};
</code></pre>
</div>


You execute a SQL statement such as this for MS SQL Server for example:
(http://msdn.microsoft.com/en-us/library/aa275462(SQL.80).aspx [http://msdn.microsoft.com/en-us/library/aa275462(SQL.80).aspx])


ALTER TABLE your_table_name
ADD COLUMN column_name {datatype};


<div>
I did not realize that it was that simple, I was searching for a much more complicated solution LOL
</div>


I did not realize that it was that simple, I was searching for a much more complicated solution LOL

<div>
<div class="content wysiwyg-content">
I have an application that is going to import data from a tab delimited text file to a table in SQL Server 2005. Sometimes the column does not already exist in the database table. What do I have to write for code to go about adding a column to the database table in vb .net?
</div>
</div>


I have an application that is going to import data from a tab delimited text file to a table in SQL Server 2005. Sometimes the column does not already exist in the database table. What do I have to write for code to go about adding a column to the database table in vb .net?

Add column to database table

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,