Home > database >  Use graphical tools to create data tables
Use graphical tools to create data tables

Time:09-20

target :

open SQL, first login,
right click need new table table ( good to round )
as shown in figure :

the right design will appear in the operation of the zone
as shown in figure :

then design ,
,
, note : length, are shown in brackets can change inside the parentheses number directly, can also change the length of the attribute in the
listed below the third as whether to allow null , is used to control when editing the empty can not fill in
after good figure :


field description in the column attribute ,
fields that are all laid the CTRL + s to save, change a name that oneself like, ,
the next step: refresh the general database ,
and then the next step: find the right click on the table and click the left before number + ,
find the new table, right-click the edit before 200 ,
as shown in figure :


NULL , you can edit the ,
  • Related