Blogs about: Foreign Key

Featured Blog

DB Constraints

sannygreddy wrote 2 weeks ago: First of all what is constraint: It is a property assigned to a column or the set of columns in a ta … more →

Tags: SQL Server, sannygreddy, DB Constraints, Primary Key, Uniwue Key, not null, check, identity

Relationships in Databases

jaimiel wrote 2 weeks ago: Everything in databases are related to another item, so they are relational. The creator can link da … more →

Tags: Database, Basics/ Intro to Database design, relationships, Relationships, Tables, unique key

Database updates

adamschrot wrote 1 month ago: This week has been a busy one, but by no means unproductive. I am glad to say that everything works … more →

Tags: Capstone Project, Relational Database, Junction table, Primary Key

Banco de dados (Hands-On)

eversonz wrote 1 month ago: Tudo gira em torno da informação e sem armazenar e obter constantemente os dados, a informática iria … more →

Tags: Banco de dados, SQL, create table, Primary Key, PostgreSQL, between, sum, inner join, LEFT JOIN

Normalization หลักการและจุดประสงค์ ตอนที่ 1

The Avatar wrote 1 month ago: ก่อนอื่นเลยเรามีดูกันก่อนว่าความหมายของการทำนอร์มัลไลเซชัน หรือที่หลายๆ คนเรียกันว่า นอร์มัลไลเนี่ยม … more →

Tags: Database, Relational Database, database normalization, boyce-codd normal form, second normal form, Edgar F. Codd, third normal form, first normal form

Untrusted Foreign Keys

sladescross wrote 1 month ago: https://www.simple-talk.com/sql/database-administration/foreign-keys-and-their-states/ ALTER TABLE t … more →

Tags: SQL, untrusted, Untrusted Foreign Keys

Can we have multiple primary keys in a single table?

Siddharth Jain wrote 1 month ago: No we Cannot. For example, CREATE TABLE IF NOT EXISTS `usr` ( `id` int(11) NOT NULL, `survey_id` int … more →

Tags: mysql, unique key, null, innodb, Data Definition Language, Tables, SQL

Login with Email Address with Django 1.5

chuckcmartin wrote 1 month ago: For at least a year we have known that Django 1.5 would contain functionality to significantly alter … more →

Tags: Django, django 1.5, Username, authenication, login, User (computing), Email Address, eMail, Uniform Resource Locator

SQL Server - Delete vs Truncate

mohsinjavaid wrote 1 month ago:   A common misconception about DELETE and TRUNCATE statements is that they do the same thing.  This … more →

Tags: SQL Server, SQL, Microsoft SQL Server, truncate, delete, codes, MS SQL

In MySQL, what are the differences between primary, foreign, and unique keys?2 comments

Siddharth Jain wrote 2 months ago: The one thing that primary, unique, and foreign keys all have in common is the fact that each type o … more →

Tags: mysql, unique key, php, MySql, Primary, Foreign, and unique keys, foreign keys, primary keys

Create table in SQL

Rami Stefanidis wrote 2 months ago: To create a table in Oracle a user will need to use the SQL language to achieve this. For example a … more →

Tags: SQL, Constraint, customer id, customer table, Oracle, Primary Key, Software, Sql Language, table tables

Foreign Key

Sahil Pirverdiyev wrote 2 months ago: Constrainsts Constraint`lər məlumatları müəyyən qaydaya uyğun olaraq nizamlayan mexanizmdir. Constra … more →

Tags: Oracle, Constraints, ORA-02292, ORA-02291

Difference between Primary key and a Unique key? What is foreign key?

Bkumar wrote 3 months ago: Both primary key and unique enforce uniqueness of the column on which they are defined. But by defau … more →

Tags: Oracle SQL, SQL, Primary Key, unique key, Oracle

How to add Foreign Key in SQL Management Studio

Isuru Madhushankha wrote 3 months ago: In this post , I am going to show you , how to add a Foreign Key to a table from an another table in … more →

Tags: technical, SQL, Database

Cursor in SQL Server

Ravi Satyadarshi wrote 4 months ago: Introduction: Hello guys, In the recent week i got  an opportunity to work with cursors in sql serve … more →

Tags: SQL-Server 2, SQL, SQL Server, Cursor

Database Normalization and Normal Forms

passionateashu wrote 4 months ago: Database Normalization: If you are doing database work from some time, you possibly have heard about … more →

Tags: SQL Core Concepts, SQL, Normalization, Primary Key, candidate key

Maintaining Data Integrity Easily With SQL Server Relationship Cascade Delete & Update Rule

gugiaji wrote 4 months ago: Maintaining Data Integrity Easily With SQL Server Relationship Cascade Delete & Update Rule SQL … more →

Tags: SQL Server, database diagram, cascade, Insert Update specification, Sql server relationship, Primary Key

Table Locks and Foreign Keys

dba010 wrote 5 months ago: Brief Description: After reading “Expert Indexing in Oracle Database 11g ” book, I decided to share … more →

Tags: DB, real world scenarios, index, Oracle, locks, FK, Performance, Improve performance

Base de datos

Moisés Moreno wrote 6 months ago: Base de datos Descripción SQL Inserción y modificación de datos Estructura de las tablas Llaves prim … more →

Tags: DB, SQL, Llaves, llave primaria, llave foránea, Primary Key, select, inner join, Join


Related Tags
All →

Follow this tag via RSS