General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>The companyID should be autogenerated by SQL Server. It will keep track of all that for you. No need to track "next ID".
>
>>Up to now we have kept different companies' data in different directories, so there hasn't been a question of which company owns a piece of data. We are now creating an add-on product that keeps its data in sql server and plan to keep several companies in the same database with a Companies table that assigns a CompanyID for each company.
>>
>>I wonder which other tables should have a CompanyID column. It seems enough to indicate companyID in the top table of a group of tables that are related as parent/child/grandchild. Or should each record of each table indicate to which company it belongs? The second alternative opens up the possibility of conflicting CompanyIDs being stored in parent, child and grandchiled records.
>>
>>I'd appreciate suggestions.
>>
>>TIA,
>>
>>Alex
It is autogenerated. Thank you.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only