Determine if table exists in SQL Server CE?
16,098
Solution 1
Yes, it does exist:
SELECT *
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME = 'TableName'
Solution 2
As an alternative you can Query the Table and catch the Exception thrown. If there is an Exception, the Table wasn't found, else the Table exists.
SELECT TOP 1 1 FROM TableName;
A little and simple Performance Test had better Results than the Query against INFORMATION_SCHEMA. Although I would consider a Query against INFORMATION_SCHEMA as cleaner.
Author by
Michael Itzoe
Updated on June 28, 2022Comments
-
Michael Itzoe almost 2 years
I know this is similar to this question, but I'm using SQL Server CE 3.5 with a WinForms project in C#. How can I determine whether a table exists? I know the
IF
keyword is not supported, thoughEXISTS
is. Does information_schema exist in CE where I can query against it? Thanks.