A list of field type names

[Daniel Kaseman]

Where can I find a reference guide that lists the different field types, and
the names (ex: NVarchar)? What if I want to make Date field? How do I
know how to programmatically create a Date field? is it NVardate?

See what I mean? Heres an example:

Dim cmd As New OleDb.OleDbCommand("CREATE TABLE People ( " & _
"AutoId int identity ," & _
"Id int NOT NULL," & _
"Name NVarchar(50)," & _
"Address NVarchar(50)," & _
"Phone NVarchar(25)," & _
"CONSTRAINT [pk_AutoId] PRIMARY KEY (AutoId)) ", conn)

But I don't know how to create different field types...

Thank you

 

[Oenone]

Where can I find a reference guide that lists the different field
types, and the names (ex: NVarchar)?

Look in the documentation for your Database engine.

If you're using SQL Server, look in the Contents of SQL Server Books Online
for Transact-SQL Reference / Data Types.

 

[Daniel Kaseman]

Where do I find that documentation in Visual Studio .Net?

 

[Herfried K. Wagner [MVP]]

Where do I find that documentation in Visual Studio .Net?

.... typically by pressing the F1 key.

 

[Oenone]

Where do I find that documentation in Visual Studio .Net?

As it's not part of Visual Studio, it's possible (though I'm not sure) that
it isn't present in the VS.NET documentation.

You wouldn't expect it to document ALL the database engines (MS SQL Server,
MS Access, MySQL, Oracle, PostgreSQL, Firebird, etc.etc.) would you?

 

[Cor Ligthert]

Daniel,

Have a look at this page.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acintsql.asp

I hope this helps,

Cor