| Author |
Topic |
|
bheema
Starting Member
12 Posts |
 Posted - 2011-11-16 : 01:09:22
|
| hi,this is bheema.how to create master table? suppose i have 60 tables how i create master table.thanks in advanceBheema |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-16 : 01:18:40
|
| what do you mean by master table? first define what according to you means master table and what information you need to keep in it.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
bheema
Starting Member
12 Posts |
Posted - 2011-11-16 : 01:46:17
|
| master means all table columns contains in one table |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-16 : 01:49:10
|
quote:
Originally posted by bheema
master means all table columns contains in one table
why should you replicate them? perhaps what you're after is a view combining the columns of all table. But then didnt get why you need to combine all columns from 60 odd tables.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
bheema
Starting Member
12 Posts |
Posted - 2011-11-16 : 01:55:56
|
| if i do any changes in master table tht wil automatically reflect the child table that means if i do any changes in master table automatically it wil change in child table. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-16 : 01:58:40
|
quote:
Originally posted by bheema
if i do any changes in master table tht wil automatically reflect the child table that means if i do any changes in master table automatically it wil change in child table.
Can you first explain need of all these? why should be you introduce redundancy like this? is this for devlopment/testing purpose?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
bheema
Starting Member
12 Posts |
Posted - 2011-11-16 : 02:05:40
|
| devlopment |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-16 : 02:07:41
|
quote:
Originally posted by bheema
devlopment
why is it that you cant use the original 60 tables itself?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
bheema
Starting Member
12 Posts |
Posted - 2011-11-16 : 02:12:22
|
| but it takes lot of time thats y we have to create master table if i do any change in tht it wil automatically changed to the child table |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-11-16 : 02:47:27
|
| Seriously, why?? Just make the changes in the real tables. Far easier, far less complex.--Gail ShawSQL Server MVP |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-16 : 03:23:02
|
quote:
Originally posted by bheema
but it takes lot of time thats y we have to create master table if i do any change in tht it wil automatically changed to the child table
that will still be additional effort as doing any changes would require to apply them in turn to all those 60 odd tables internally------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
master table