In Microsoft SQL Server database, a table is basically a list of items or a group of those item lists. To manage these lists, it is necessary to organize them in a meticulous manner. For organizing all this information, what is done is that the info is divided into various sections. Based on this segregation, the lists are simply the arrangement of info, also called data, which is stored in tables.

Rows and Columns: The information of the tables is systematically organized in categories, wherein the vertical arrangements are termed as columns and horizontal arrangements are called records or rows.

Column of a Table: In a table, the column holds that category of data, which is common to all the records. It is imperative for any table to have at least one column. This means that, a table cannot be created without defining at least one column in it.

About Tables Names: For completely creating a table, it is necessary for you to save it. In case, you are creating a fresh table and you try saving it, then you would be prompted to name that table.

Rules for Naming a Table: An SQL database table name can be made as follows:

• An SQL database table name can be made of digits only. For example, you can have a table called 182
• An SQL database table name can start with a digit, a letter, or even an underscore
• An SQL database table name can be made of letters, digits, and spaces

Besides these rules mentioned above, you can also make up your own rules.