What is a FakeSystemTable ? ( table which references a system table ??? )

Question

Hello,

 

Please, could you give an explanation of a FakeSystemTable ?

 

I found a definition on this link :

http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.table.fakesystemtable.aspx

 

Definition found :

A Boolean value that specifies the whether the table references a system table. If True, the table references a system table. Otherwise, False (default).

 

Not really clear...

 

How can i create a FakeSystemTable ? ( not in SMO but with Transact-SQL )

What is the use ?

 

I found nothing in the book of K.Delaney ( The storage engine ) . But , i may have missed something

In the BOL, nothing... ( but my eyes are very tired now )

 

The origin of this question : i have discovered that AdventureWorks has 71 tables, but when i subtract the system tables ( IsSystemObject ) or FakeSystemTable.

As the creation script is long ( more 2,500 lines ) , i have not found anything ( a doubt about sys.diagrams )

 

Thanks beforehand

 

Have a nice day

 

Answer 1

Hi,

Table.FakeSystemTable Property is applicable only for SQL 7 and 8 and corresponds to the OBJECTPROPERTY(table_id,'TableIsFake') From SQL 9 onwards it is always false.
It is present due to backward compatibility reasons. I have check if it has been added to deprecation list or not.

http://msdn.microsoft.com/en-us/library/aa276849(SQL.80).aspx


Regards,
Alok Parmesh

Answer 2

Hello,

 

Many thanks for your reply

I was desesperate to see my question with no answer and i was thinking to delete it

 

Euh, just a small question ( no answer with Google ) : what is the meaning of the 4 characters MSFT ( MS Microsoft but FT ...) ?

 

Have a nice day

Answer 3

Hi,

 

MSFT is stock quote of MicroSoFT on NASDAQ.

I found MS employees using MSFT after their names. So, I also started using it.

 

Regards,

Alok Parmesh

Answer 4

 

MSFT can also be Microsoft Full Time (Employee).