Post reply

can we give a copy of a database to someone and it be packaged in such a way so that they cannot see the table structure / design?

  • April 19, 2013 at 3:24 am

    #276689

    can we give a copy of a database to someone and it be packaged in such a way so that they cannot see the table structure / design????????

    Thanks in advance,

    suresh.

  • April 19, 2013 at 3:48 am

    #1608128

    No.

    Give someone a database and you're giving them full and complete control over the schema and data.

    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

  • April 24, 2013 at 10:18 am

    #1609621

    What are you trying to achieve Suresh?

    Even if you provided all of the data in .csv files or in a massive Excel spreadsheet the person will still be able to see the layout of the tables, although they wouldn't be able to see any of the key relationships, triggers, indexes, stored procedures etc...

    SQL SERVER Central Forum Etiquette[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

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