sys.tables.type

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Recent Posts

Popular Topics

Home

Home » SQL Server 2008 » T-SQL (SS2K8) » sys.tables.type

Add to briefcase

sys.tables.type

Expand / Collapse

Author

Message

Posted Tuesday, September 25, 2012 9:52 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 9:07 PM
Points: 162, Visits: 336

Hi,
What does sys.tables.type meant.

Post #1364413

Posted Tuesday, September 25, 2012 10:01 PM

SSCrazy

Group: General Forum Members
Last Login: Today @ 3:37 AM
Points: 2,340, Visits: 3,165

Look at the type column described here:

http://msdn.microsoft.com/en-us/library/ms190324.aspx

I believe sys.tables returns only type='U'

No loops! No CURSORs! No RBAR! Hoo-uh!

INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?

Need to UNPIVOT? Why not CROSS APPLY VALUES instead?
Since random numbers are too important to be left to chance, let's generate some!
Are you too recursively challenged?
Splitting strings based on patterns can be fast!

Post #1364417

Posted Tuesday, September 25, 2012 10:02 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 9:07 PM
Points: 162, Visits: 336

Thanks dwain eventually find out what was needed.

Post #1364418

« Prev Topic | Next Topic »

Add to briefcase

Permissions

Expand / Collapse