The Primary Key tab contains information about an optional primary key for the table. If you don't enter a required attribute or enter an attribute that is unsupported for a data type, you will get an error message when you click Execute to create the table. For instance, there is no metadata available to tell if a data type requires, or allows, a size. The Create Table dialog uses database metadata to try to enable only the fields that apply to the selected data type, but please note that it is not always possible. The Auto Increment field, and possibly Start With and Increment By fields, are shown for numeric fields if the database supports automatically inserting the next available sequence number in a numeric column.
0 Comments
Leave a Reply. |