Step 4: Manipulate the Data (ADO Tutorial) Schema
The following is the schema of the Authors table of the Pubs database:
| Column Name | Data Type (Length) | Nullable |
| au_id | ID (11) | no |
| au_lname | varchar(40) | no |
| au_fname | varchar(20) | no |
| Phone | char(12) | no |
| Address | varchar(40) | yes |
| City | varchar(20) | yes |
| State | char(2) | yes |
| Zip | char(5) | yes |
| Contract | bit | no |
Return to Step 4: Manipulate the Data