Newer
Older
labs / tiddlers / content / labs / lab03 / _Labs_03_Test your connection.md
Before we start the task for today we will test that we have our set up correct.  
Write a simple create table statement.  
```plaintext
CREATE TABLE test(  
UserName varchar(10)  
);  
```   
Control Enter will run the statement or use the buttons on the left.  
Right click on the gutter between the statements and controls and select line numbers, this can be helpful to find errors.  
Check the Navigator window to see if it created ok. No?  
Right click on the WaterSample database in the navigator and go refresh.  
Can you see table test now?  
Try insert some data.  
```plaintext  
INSERT INTO test (UserName) values ('Dr Dick');
```
Control Enter to run the insert statament.   
Now we test that it worked by interrogating the database with a SELECT statement.  
```plaintext  
SELECT * FROM   test;  
```
to check it is there.  
```plaintext  
DROP TABLE test;
```
Test completed, clear out the the test table and we are ready to start work.