Some Tips of Table Structure

This page tells some of the great tips about table structure. Some of the tips are explained below:

Table creation time:

Tables can be created at any time. Users can also create tables at the time of using database. 

Size of the table:

There is no restriction regarding the size of the table. Moreover, you don't need to specify the size of the table. But, it's important for estimating the space required of the table which will be used by that table in future.

Modifying structure:

The structure of the tables can be modified online. 

Naming convention:

Table name begins with letters and no reserved words. For details, naming Convention of Tables and columns.

Size of table columns:

A table can have up to 1000 columns.