• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
key preserved table ?
#1
Hello Dear,

               Please Tell Me What is key preserved table ?
Reply
#2
A key-preserved table is a base table with a one-to-one row relationship with the rows in the view, via either the primary key or a unique key.
Cheap VPS | $1 VPS Hosting
Cheap Windows VPS | Windows with Remote Desktop Access
Cheap Dedicated Server | $29 Dedicated Server with Free IPMI
Reply
#3
A table is key preserved if every key of the table can also be a key of the result of the join. In key preserved table rows from the base appears at most once. Key preserved table guarantees to return only one copy of each row from the base table.
Reply


Possibly Related Threads...
Thread Author Replies Views Last Post
  Find The Number Of Rows In A Table Using Mysql ? rajshreedixit01 3 121 09-26-2019, 01:29 AM
Last Post: emmablow
  How many TRIGGERS are allowed in MySql table? gitanistone 0 67 09-25-2019, 01:19 AM
Last Post: gitanistone
  How can you see all indexes defined for a table? gitanistone 0 46 09-25-2019, 01:07 AM
Last Post: gitanistone
  What, if a table has one column defined as TIMESTAMP? gitanistone 0 40 09-25-2019, 01:05 AM
Last Post: gitanistone
  How do you control the max size of a HEAP table? gitanistone 0 36 09-25-2019, 01:03 AM
Last Post: gitanistone
  What is the syntax to add a record to a table In Sql ? snehareddy 0 29 09-21-2019, 12:44 AM
Last Post: snehareddy
  select all records from the table In Sql ? snehareddy 0 75 09-21-2019, 12:43 AM
Last Post: snehareddy
  Table Scan from Index Scan ? angilpari1122 1 101 09-13-2019, 05:38 AM
Last Post: Paro
  How to add Serial No. to first column of specific Table only sulbha 0 215 10-18-2017, 04:42 AM
Last Post: sulbha
  How to write data from MySql table to Excel using Java - See more at: https://www.gid richardwalter 0 490 02-11-2017, 04:47 AM
Last Post: richardwalter

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
1 Guest(s)


Webmasterbabble.com, © 2012-2019 .