DB Tools Create Table VI

Owning Palette: Database VIs and Function

Requires: Database Connectivity Toolkit

Creates a new table in the database identified by connection reference. The table and column information inputs describe the name of the table and the properties of each column in the table, respectively.

Examples

	primary key specifies the column that is going to be the primary key for the table. The default is –1, which means the table does not have a primary key.
	connection reference specifies a reference to an ADO Connection object.
	table is the name of the table in the database to create.
	column information specifies an array of clusters that describe each column to be created. column name specifies the name of column in database. data type specifies the data type of the column. 0 String 1 Long (I32) 2 Single (SGL) 3 Double (DBL) 4 Date/Time 5 Binary size specifies the size of the column in the database. This VI uses this parameter for string data types only. If you specify a size of 0, the database provider specifies the maximum string size. allow null? specifies if the column allows NULL values.
	error in describes error conditions that occur before this node runs. This input provides standard error in functionality.
	use file? specifies whether to use a user-supplied file to determine native database types. The default is FALSE.
	connection reference out returns a reference to an ADO Connection object.
	error out contains error information. This output provides standard error out functionality.

Examples

Refer to the following VIs for examples of using the DB Tools Create Table VI:

• Create DatabaseTable VI: labview\examples\database
• Sixtypes Insert VI: labview\examples\database