Categories

Tools

bitdefender

1&1 Web Hosting
Code Snippets » Access » Create a new table by using the CREATE TABLE statement in the Data Definition Language (DDL)

Create a new table by using the CREATE TABLE statement in the Data Definition Language (DDL)


Access creates the database tables in a variety of ways:

  • Create a table in Design view
  • Create a table using a wizard
  • Create a table by entering data


Or using the functions:

  • Import ...
  • Link tables


But in some cases it is useful to be able to create tables with DDL statements, such as CREATE TABLE. Using the CREATE TABLE statement, you can define a new table and its fields and field constraints. The following example shows how to create a Customers table.

CREATE TABLE Customers
( 
ID 	integer primary key,
Company varchar(50),
Name 	varchar(50),
Surname 	varchar(50),
Title 	varchar(30),
Address 	varchar(60),
City 	varchar(20),
PostalCode varchar(15),
Country 	varchar(15),
Phone 	varchar(25),
Email 	varchar(60)
)

 

Posted in Access by MdmSoft

If our work has been of help, you can help us with a small donation...
Our programmers will thank you!

Related code snippets Related code snippets posted in Access:


Recommended Books The best Access recommended books:


All information contained in this web site are the property of MdmSoft. The information is provided "as is", MdmSoft will not be liable for any misuse of the code contained in these pages, nor can it be for inaccuracies, grammatical errors or other factors that may have caused damage or lost earnings. MdmSoft is not responsible for the content of comments posted by users.
The examples in this area have the educational and demonstration purposes only, and may be copied only for your reference, but cannot be used for commercial purposes, or for any other purpose, without the express written consent of MdmSoft.
MdmSoft also reserves the right to change, without notice, to your liking this web site, the pages and its sections, and may suspend temporarily or definitely the various services included on this site.
While using this site, you agree to have read and accepted our Terms of Service and Privacy Policy.