This article contains the SQL CREATE TABLE syntax, as implemented by various database management systems (DBMSs). The syntax is listed exactly as each vendor has listed it on their website. Click on the applicable link to view more detail about the syntax for a particular vendor.
Once you’ve created your table, you will need to add fields (these will contain the data). You will also need to specify the type of data that the fields will contain (eg, text, number, date, etc).
You can also add extra rules about the type of data that can be entered into each field (eg, that phone numbers should be entered this way, dates should be entered that way, etc), as well as other properties for each field.