Table Naming Conventions

 Table Naming Conventions:

*************************

We need to follow below rules.

-->Table name should not start with numbers.

-->The name must begin with a letter A-Z or a-z,(0-9,or _,$,#)

-->Can contain numbers and underscores.

-->Maximum length it should be 30 characters

-->Can be in upper or lower case

-->Can not use the same name.

-->size of the table need not be specified

-->Names can not be oracle server reserved keywords.

-->Table names are not case sensitive in oracle.

-->The structure of the table can be modified.

Example:

********

Name:                             Valid?

*********                         ***********

Emp or emp                        Yes

5EMP or 10emp                     No --Should not begin with a number

Emp_Details                       Yes

Emp Details                       No--Should not contain a blank space between the name

emp-details                       No-Should not contain a Hyphen between the name

DELETE                            No--'DELETE' is a sql reserved word.

'