CODEWITHSUNDEEP
sqlsql-serversystem-tables
ANJi
ANJi

Reputation: 27

How can I know why the particular columns are created and according to what the columns are update in System Base Tables?

I have one doubt related to SQL Server System Base Tables.

How can I know why the particular columns are created and according to what the columns are update in System Base Tables?

For example in sys.sysschobjs system base table maintaining details about all objects created in database.This table contains nsclass,pclass,status,intprop these columns. how to know about on what basis these columns has values in that ? nsclass contains 0, why 0 is updated in that column for particular object and also status column contains 1 for stored procedure why these value ? can I know about that ?

Upvotes: 0

Views: 47

Answers (0)

Related Questions