Post reply

physical relation in datatables in sql server

  • August 29, 2011 at 8:21 am

    #256442

    Hi,

    What is physical relation between data tables in sql server.

    Foreign key relation is treat as Logical relation. But i don't know is there any physical relation exists.

    Can any body explain me what is physical relation between data table.

    Thanks,

    Vego.

  • August 29, 2011 at 8:32 am

    #1374507

    Err, there isn't any physical relationship between tables.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 2, 2011 at 1:29 am

    #1376288

    Table is a logical concept in case of RDBMS. but files are physical concepts. There will be no physical relation between tables.

    SQLforU
    info@sqlforu.com
    For online training on SQL Server and Sybase, please contact
    contact@sqlforu.com
    www.sqlforu.com

  • September 2, 2011 at 2:29 am

    #1376306

    Tables are logical entities within a database and its files, as are their relationships. Relationships are more like enforced rules. The closest thing to "physicality" are the magnetic bits on/in the drive it resides.

  • September 2, 2011 at 5:22 am

    #1376367

    you're not thinking of physical and logic data models are you?

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply