Loading...
Please wait...
[
Log In
]
Online Data Modeler
Home
Home
Public Models
Pricing
Site Map
Model
Versions
Generate SQL
Database
Account
Log In
Register
Help
Content
Forum
List Topics
Topic
Version:
1
Overview
Table
Diagram
View
Procedure
Function
Trigger
Create New Table
Tables
CandidateDetail
CityDetail
CompanyDetail
CountryDetail
DomainDetail
ExperienceDetail
Functional_Area
HSCDetail
Language Reference
LanguageDetail
PGCourseDetail
PGDetail
PGUnivserityDetail
SkillDetail
SSCDetail
StateDetail
UGCourseDetail
UGDetail
UGUniversityDetail
Table CityDetail
Comment:
Save
Delete Table
Rename Table
New Column
Columns
Name
Data type
Not NULL
Primary key
Length
Decimals
Default
AutoInc
Comment
CityID
Int
Ids for the City
Name
NVarChar
100
Name of the cities
Primary Key
Add Index
Add Unique
Add Foreign Key
Keys & Indexes
Name
Type
Columns
Primary Key
CityID
Foreign Keys
This table doesn't contain any keys.
Static Data
CityID
Name
Add data row
Name:
Data type:
BigInt
Binary
Bit
Char
Date
DateTime
DateTime2
DateTimeOffset
Decimal
Float
Image
Int
Money
NChar
NText
NVarChar
Real
UniqueIdentifier
SmallDateTime
SmallInt
SmallMoney
Text
Time
Timestamp
TinyInt
VarBinary
VarChar
Variant
Xml
Numeric
Generic
Not NULL:
Primary key:
Length:
Decimals:
Default value:
Auto increment:
Comment:
Add Column
Name:
On delete rule:
Undefined
Cascade
Restrict
Set NULL
No Action
On update rule:
Undefined
Cascade
Restrict
Set NULL
No Action
Child cardinality:
One
More
Child optionality:
Mandatory
Optional
Add Column
Name:
Unique:
Schema:
Name:
Operation cannot be finished, because some limits are exceeded.
Upgrade Now
Object
Used
Added
Required
Limit