Please enable JavaScript.
Coggle requires JavaScript to display documents.
Database Objects - Coggle Diagram
Database Objects
Schemas
Tables
Columns(Attributes)
Rows(Tuples)
Views
Functions
Function Meta
Return Type
Function Name
Parameters
Paramter Name
Parameter Type
Default value
Stored Procedures
Name
Parameters
Parameter Name
Parameter Type
Triggers
Types
Instead of Triggers
After insert Triggers
After update
before insert
Transactions
Custom Type
Constraints
Primary key
Foreign key
Cascade on delete
cascade on update
Unique Keys
Check constraint
Null
Not null
Default constraint
Cursors
Users
Login
Synonyms
Rules
Filegroups
DQL
Select
Group
Where
Order By
JOin
Innser join
left join
right join
full join
operators
membership operators
DML
Insert
Update
Delete
DDL
Create
Drop
DCL