Default Column value : Table Create « Access « VBA / Excel / Access / Word

Home
VBA / Excel / Access / Word
1.Access
2.Application
3.Data Type
4.Data Type Functions
5.Date Functions
6.Excel
7.File Path
8.Forms
9.Language Basics
10.Math Functions
11.Outlook
12.PowerPoint
13.String Functions
14.Windows API
15.Word
16.XML
Microsoft Office PowerPoint 2007 Tutorial
Microsoft Office Excel 2007 Tutorial
Microsoft Office Word 2007 Tutorial
VBA / Excel / Access / Word » Access » Table Create 
Default Column value
 
Sub CreateDefault()
    Dim cmd As ADODB.Command
    Set cmd = New ADODB.Command

    cmd.ActiveConnection = CurrentProject.Connection
    cmd.CommandText = "CREATE TABLE Customers " & _
        "(CustomerID LONG CONSTRAINT CustomerID PRIMARY KEY, " & _
        "CompanyName TEXT (50), IntroDate DATETIME, " & _
        "CreditLimit CURRENCY DEFAULT 5000)"
    cmd.Execute
End Sub

 
Related examples in the same category
1.Create a table with validation rule
2.Creating a Table (ADOX data types vs. Microsoft Access data types)
3.Creating a Table in the Current Database with SQL statement
4.Creating a Table in a New Database with AUTOINCREMENT column
5.Creating a Table with a Single-Field Index with SQL command
6.Adding a Single-Field Index to an Existing Table with SQL command
7.Creating an Index Based on Two Fields with SQL command
8.Creating Check Constraints:add business rules for a table
java2s.com  |  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.