What are naming convention standards for tables in SQL Server

Table :

                * It is the collection of rows and columns , row can be called record or touple . Column can be called field or   attribute

                * The insertion of row and column can be called as cell , a cell is a place where we can store our data

                * The other name of table can be called as entity

Rules for naming a table :

                * A table name can have maximum upto 30 charecters

                * Alphabets from A to Z , a to z and numbers from 0-9 are allowed

                * A name should begin with alphabet

                * SQL reserved words are not allowed

                * The use of special characters like '_' is allowed and also recommended, the special characters like #,$ are allowed   in ORACLE but not in SQL Server .

                * A table can have minimum 1 column, maximum 1024 columns

                * We can enter 'n' number of records into the table i.e upto hard disk capacity , it means that table contain minimum 0   Records, maximum number of records .

how to see the structure of the table

To see the structure of the table we can use one system defined stored procedure

                sp_help <Table-Name>

Structure=Definition, structure or definition means columns in the table