July 17, 2008 at 12:37 am
Hi everybody,
I got some serious problems understanding the true meaning of Catalogs an Schemas in SQL Server 2005. I don't know what can I do with them after knowing them thoroughly. But for sure, it will help me to conceptualize database and server concepts better. If anyone can explain the difference between them not using "Difficult-to-Understand-Pro-Programmers-Language" scenario, please help me.
July 17, 2008 at 12:47 am
Schema is the data model that defies the set of objects like Sales schema grouops the sales related objects like Sales.SalesSummary, Sales.SalesDetails, Sales.SalesComminion. HR schema groups the HR related objects like HR.Candidates.. You can set the permissions who can acces that schema objects.
Catalogs are maintain in FULL-Text Search, which is use for Wide search like we search anything in google. these catalogs contains tables & columns which defines on which table FTS can be perform & on which columns.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply