A Composite primary key is a set of columns whose values uniquely identify every row in a table. What it means is that, table which contains composite primary key will be indexed based on columns specified in the primary key. This key will be referred in Foreign Key tables. For example – if combined effect […]
What is a Composite Primary Key ? Read More »
A primary key is a column whose values uniquely identify every row in a table. Primary key values can never be reused. If a row is deleted from the table, its primary key may not be assigned to any new rows in the future. To define a field as primary key, following conditions had to
What is a primary key? Read More »
What are properties of a transaction?
What are properties of a transaction? Read More »
What is a database transaction?
What is a database transaction? Read More »
What is a Record in a database ?
What is a Record in a database ? Read More »
What is a Table in a database ?
What is a Table in a database ? Read More »
what is a field in a database ?
what is a field in a database ? Read More »
What are the different type of SQL or different commands in SQL?
What are the different type of SQL or different commands in SQL? Read More »