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

Autodesk ArtCAM 2017 Crack + Patch + Full Version

Autodesk ArtCAM 2017 Crack + Patch + Full Version ArtCAM is, in fact, a design tool designed more for designers than engineers, and allows designers to showcase their creativity. The software delivers a CNC modeling CAD that can be used for a variety of industries. For example, designers of signs, woodcutters, jewelry designers and many others who can produce high-quality products before they can deliver their products in two-dimensional and three-dimensional form. It's easier with this software than ever. Features and Features of ArtCAM 2017 Crack + Patch + Full Version: Support for 64-bit systems Ability to mount jewelry pieces The ability to create complex shapes Ability to cut different pieces of pages The ability to create floating vectors Save layers and shapes that you must use Availability of ready-made models available System Requirements for ArtCAM 2017 full Crack for 2017, 2018: OS: Windows 7 SP1 / 8.x / 10 for 2012: Processor Type & Speed: Intel Core 2 Duo (or equiv...

Move up and down listbox item using javascript

     In the following example,we can easy to move the list box item up and down using javascript code. Example     function listboxMove(listID, direction) {       var listbox = document.getElementById(listID);       var selIndex = listbox.selectedIndex;       if (-1 == selIndex) {         alert("Please select an option to move.");         return;       }       var increment = -1;       if (direction == 'up')         increment = -1;       else         increment = 1;       if ((selIndex + increment) < 0 ||         (selIndex + increment) > (listbox.options.length - 1)) {  ...

Adobe Acrobat Pro DC 2019 Portable (v19.010.20064)

Adobe Acrobat Pro DC 2019 Portable (v19.010.20064) is a software for creating PDF files. With the help of this software, the user can convert all text files, photos and other relevant documents to PDF format. Adobe Acrobat software is popular with many software users due to the compatibility with most software. You can plan it in the printer's configuration area by typing Ctrl + P keys that are specific to print operations, print texts or anything printable in Adobe Acrobat as a PDF. Adobe Acrobat software features Ability to convert to other formats like images and Word Scan directly from the scanner The presence of internal OCR to identify texts Optimized mode for displaying documents as much as possible Specific compatibility with high-quality images to showcase the best of the documents Ability to do things in a batch like conversion Ability to add new actions to PDF documents Ability to interconnect multiple PDF documents Ability to build form System Requirements Operating Sys...