var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Table exists
How do i check if to if a table exists in a database?
declare @TableName sysname
set @TableNAme = 'test'
if OBJECTPROPERTY(OBJECT_ID(@TableName),'IsTable') = 1
Found it on this forum. Thanks
select * from sysobjects where xtype='U' and name='yourtable'
I've always selected from sysobjects using the 'type' column (e.g. select * from sysobjects where type ='U')
What is the difference between these columns? (type vs. xtype)
xtype differentiates between pk and unique constraint, while type has the same value for both. type also identifies rule.
Yup, saw that in BOL, just wonderin' if there was an intended purpose for having both or is one to go away in a future release...
i think xtype is to stay. type was passed on from 6.5 era.