The instructions below show you how to add a new column to the table tblVeterinarians, using a SQL script typed manually. The new column should be called "Email" and its data type should be varchar(50).
|Note:||Entering a SQL statement is just one of the ways to add columns to an existing table. You can also add new columns visually from the Design Editor; see Adding Columns.|
To create the new column:
1.Open the "ZooDB" project created previously and double-click the ZooDBConnect data source to connect to it.
2. Click the SQL Editor toolbar button to open a new SQL Editor window.
3.Start typing "alt". The auto-completion helper pops up.
4.Press Enter. The word "ALTER" appears in the SQL Editor.
5.Start typing "tab" and add the word "TABLE" after "ALTER". Your SQL statement should now be "ALTER TABLE".
6.Press Space, and then press Ctrl+Space to manually trigger auto-completion.
7.Select "tblVeterinarians" from the list and press Space.
8.Continue creating the SQL statement until you have typed the following text:
ALTER TABLE [tblVeterinarians] ADD Email VARCHAR (50)
9.Execute the SQL statement by clicking the Execute button or pressing F5.
You have now created the new Email column. To view it in the Online Browser, click the Refresh database button.