Overview of Inserting and Deleting Data
After creating a data dictionary, tables, and columns, you can add data to the database using SQL Data Manager. SQL statements allow you to do the following:
•
Specify literal values to insert.
•
Select data from other tables and insert the resulting values into entire rows or specified columns.
When you insert a literal value, it must conform to the specified column’s data type and length.
You can drop (delete) rows, indexes, columns, or tables from your database. In addition, you can drop an entire database when you no longer need it.