Common Database structure

Common Database structure

1- Table: Common structure in database is a table .table consist of columns and rows in which data is stored .the intersection of a column and  a row is called a field.

2-     View: a view is a logical symbol of subsets of data from one or more database table.

3-     Sequence: generate unique numbers. You can it to generate Primary key

4-     Synonym: alternate names for tables or for other database object

5-     Index: by using the index object you improve the performance of queries.

Note: that you can create and modify table structures while database in used.