Showing posts with label Constraints in SAP HANA. Show all posts
Showing posts with label Constraints in SAP HANA. Show all posts

Tuesday 1 August 2017

Foreign Key in SAP HANA


v  A foreign key is a column (or columns) that references a column (most often the primary key) of another table. The purpose of the foreign key is to ensure referential integrity of the data. In other words, only values that are supposed to appear in the database are permitted.

Primary Key in SAP HANA

v  For some applications, it is useful to uniquely identify the rows in a table by one or more columns so that you can process them in a specified sequence, for example. You can do this by assigning a primary key. The column names that are to create the table key are represented by the keywords PRIMARY KEY. The input values of the key columns defined in this way must not be a NULL value.