Guidelines for creation of table, Database Management System

Guidelines for creation of table:

  • Table name should begin with an alphabet.
  • In table name, single quotes and blank spaces are not allowed.
  • Reserve words of that DBMS cannot be used as table name.
  • Size and Proper data types should be specified.
  • Unique column name should be specified.

 

Posted Date: 3/11/2013 12:54:52 AM | Location : United States







Related Discussions:- Guidelines for creation of table, Assignment Help, Ask Question on Guidelines for creation of table, Get Answer, Expert's Help, Guidelines for creation of table Discussions

Write discussion on Guidelines for creation of table
Your posts are moderated
Related Questions
Backward Recovery (UNDO): In this system the uncommitted changes made by a transaction to a database are undone.  Instead the system is reset to the last consistent state of databa

Boyce-Code Normal Form (BCNF) A relationship is said to be in BCNF if it is already in 3NF and the left hand side of each dependency is a candidate key. A relation who is in 3N

Explain the integrity constraints: Not Null,  Unique, Primary Key with an example each. Is the combination 'Not Null, Primary Key' a valid combination. Justify. Not Null - Shou

What is Interaction Diagram An interaction diagram shows an interaction, comprises of a set of objects and their relationships including the messages that may be dispatched be

What is abstraction? Abstraction in the object orientation is a idea that provide opportunity to express necessary properties of object without providing much details of the im

sql is relationally complete-justify

Accessing information about permissions to all users- Object level permissions: With the use of data dictionary you can see the permissions to user. Let us get the table name fro

What is Log Shipping? Log shipping is the method of automating the backup of database and transaction log files on a production SQL server, and then restoring them onto a stand

er diagtram for icici

What are called journaling file systems? File systems that support log disks are known as journaling file systems.