Bookmarks
Account
ACL
Tools
New
Other
New TableTables are an essential Tool within your Younicycle account. We do not currently impose a limit on the number or size of Tables within an Account.
There are many web resources available that discuss Tables & database design + hundreds of forums. But - if you go to a forum and ask a question about Younicycle - the response is likely to be, "What the heck is a Younicycle? Are you sure you are in the correct forum?"
Younicycle runs on PostgreSQL, the World's Most Advanced Open Source Database and multiple winner on Linux Choice Awards. Database terminology does differ between Oracle, MySQL, DB2, PostgreSQL and others. We use terms that a common user should understand. We may point to other, supplemental web reference material. If you know a good resource or would like to include a relevant article, contact us with details. You will get proper attribution for your effort.
There are many web resources available that discuss Tables & database design + hundreds of forums. But - if you go to a forum and ask a question about Younicycle - the response is likely to be, "What the heck is a Younicycle? Are you sure you are in the correct forum?"
Younicycle runs on PostgreSQL, the World's Most Advanced Open Source Database and multiple winner on Linux Choice Awards. Database terminology does differ between Oracle, MySQL, DB2, PostgreSQL and others. We use terms that a common user should understand. We may point to other, supplemental web reference material. If you know a good resource or would like to include a relevant article, contact us with details. You will get proper attribution for your effort.
To begin creating a New Table, mouse over (Top Menu) New. A list of possible objects will drop down. Select Table.
That simple action is already beginning the process of creating SQL on line, within your Schema (Account).
The GUI for Younicycle is designed to make life easier for non developers and also, to preclude user errors that could cause errors.
Below is a snip of applicable text from the PostgreSQL user manual. Bolded is for emphasis:
CREATE TABLE will create a new, initially empty table in the current database. The table will be owned by the user issuing the command.
If a schema name is given (for example, CREATE TABLE myschema.mytable ...) then the table is created in the specified schema. Otherwise it is created in the current schema. Temporary tables exist in a special schema, so a schema name cannot be given when creating a temporary table. The name of the table must be distinct from the name of any other table, sequence, index, or view in the same schema.
The full page of referenced material can be found at:
PostgreSQL Manual (Create Table)
That simple action is already beginning the process of creating SQL on line, within your Schema (Account).
The GUI for Younicycle is designed to make life easier for non developers and also, to preclude user errors that could cause errors.
Below is a snip of applicable text from the PostgreSQL user manual. Bolded is for emphasis:
CREATE TABLE will create a new, initially empty table in the current database. The table will be owned by the user issuing the command.
If a schema name is given (for example, CREATE TABLE myschema.mytable ...) then the table is created in the specified schema. Otherwise it is created in the current schema. Temporary tables exist in a special schema, so a schema name cannot be given when creating a temporary table. The name of the table must be distinct from the name of any other table, sequence, index, or view in the same schema.
The full page of referenced material can be found at:
Please remember - do not post questions about Younicycle to any PostgreSQL list. The best you could hope for would be: "Huh?"
Type
Continue by clicking the numbered boxes above.
New Table
2
1
3
4
5
6
7
8
9
10
11
New Table
Name Describe
Add Columns
DataTypes
TableStructure
TableOptions
DataEntry
ImportData
StoreExport
AddConstraints
Indexes Keys