Chuyển đến nội dung chính

Naming standards for SQLite

Naming Conventions for SQLite
     Each database, table, column, index, trigger, or view has a name by which it is identified
and almost always the name is supplied by the developer.The rules governing how a
valid identifier is formed in SQLite are set out in the next few sections.

Valid Characters
     An identifier name must begin with a letter or the underscore character, which may be
followed by a number of alphanumeric characters or underscores. No other characters
may be present.

These identifier names are valid:
   mytable
   my_field
  xyz123
  a

However, the following are not valid identifiers:
   my table
   my-field
   123xyz


Name Length
     SQLite does not have a fixed upper limit on the length of an identifier name, so any
name that you find manageable to work with is suitable.
Reserved Keywords
Care must be taken when using SQLite keywords as identifier names. As a general rule
of thumb you should try to avoid using any keywords from the SQL language as identifiers,
although if you really want to do so, they can be used providing they are enclosed
in square brackets.
For instance the following statement will work just fine, but this should not be mimicked
on a real database for the sake of your own sanity.
sqlite> CREATE TABLE [TABLE] (
...> [SELECT],
...> [INTEGER] INTEGER,
...> [FROM],
...> [TABLE]
...> );

Case Sensitivity
     For the most part, case sensitivity in SQLite is off.Table names and column names can
be typed in uppercase, lowercase, or mixed case, and different capitalizations of the same
database object name can be used interchangeably.
SQL commands are always shown in this book with the keywords in uppercase for
clarity; however, this is not a requirement.

Note
The CREATE TABLE, CREATE VIEW, CREATE INDEX, and CREATE TRIGGER statements all store
the exact way in which they were typed to the database so that the command used to create a database
object can be retrieved by querying the sqlite_master table. Therefore it is always a good idea to format
your CREATE statements clearly, so they can be referred to easily in the future.

Nhận xét

Popular Posts

Sugar Panic flash puzzle game

Play Sugar Panic, a free online puzzle game. Tags: ball games, candy games, kiz10 games, monster games, panic games, physics based games, roll games, sugar games, sweet games

Format Factory v3.3.5.0

Description:- Format Factory is a free audio, video and photo converter that supports a large range of formats for encoding and ripping. You can convert either single files or entire folders from one format to another. Presets for portable devices make it easy to create audio and video files that can play on your Android phone or tablet, iPhone, iPad, iPod or Blackberry. Format Factory lets you rip your favorite DVDs and Music CDs to create a copy of your films and songs on your local hard disk or any portable storage drive. If your media files are corrupted, Format Factory can help to repair them. While converting pictures, Format Factory allows rotation and zoom as well as adding of tags and watermarks.  The program also comes with an AV Mux tool. Video formats: MPG, WMV, 3GP, FLV, SWF, MP4, AVI, ... Audio formats: WAV, WMA, OGG, MP3, AAC, AMR, ... Image formats: PNG, JPG, TIF, ICO, BMP, GIF, TGA, ... And Many More....... Previews:- Download Link:- Download Format Factory Passwor...

ARTCUT 2009 Software USB Driver Free Full Download

Download ARTCUT 2009 Software USB Driver Full Free latest version offline setup for Microsoft Windows 7, 8,  10, XP, Vista. ARTCUT 2009 Software USB Driver is one of the best especially designer inside the agency of cutting plotter machine for operating. ARTCUT 2009 Software USB Driver Overview Artcut 2009 is the 3D realistic programming worked for 5-pivot laser cutting on Without it, with a well-ordered direction through the whole programming procedure. ArtCut programming self-sufficiently amends the courses of the hub in order to avoid crashes with the piece or different components of the machine.  Artcut 2009 Software PC programming is extraordinarily structured inside the organization of plotter cutting for working. You can undoubtedly make, do shrewd trimmings of plastic cutting. It can likewise e create legitimate plotter cuttings. You can have the chance of extra set up for the essential period of work. Stage pay, corner changes, and obtaining methods may...