Linx Consulting, Inc.
10491 S. Hyacinth St.
Highlands Ranch, CO 80129-5412
(303) 916-5522
  spacer
 
     
Home
Products & Services
Database Tips
Of Interest
Last Updated on 6/27/2008
 
Product Samples

(click repeatedly to view a randomly selected set of product samples)

Click to Learn More!
     
 

Avoid Using Reserved Words

Reserved words are words used within database and application development software in order to name the objects and procedures that are built into the development environment. If you use these reserved words to name your own application and database objects, your application may become "confused" about which object you were refering to, which can lead to unexpected results or system failure.

For example, if you created a field named "Date" to store the date that new records were created and there is also a Date function within your application development environment, the software will have to make a decision about what you meant based on the context where the name is used. Most applications allow you to add delimiters to your object names to tell the software what you mean but that can slow down your programming efforts and make your code harder to write and understand.

To avoid problems altogether, use names that aren't reserved words. In the example above you could use names like DateCreated or CreationDate.

 
     
     
 

Copyright © 2007 - Linx Consulting, Inc.

PostgreSQL Powered
Database Development

Advanced Solutions International, Inc