INFORMATION_SCHEMA Views in SQLServer CE

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

zacks@construction-imaging.com - 22 Feb 2008 16:27 GMT

Do the INFORMATION_SCHEMA Views in SQL Server CE have the same layout
(columns returned and their datatypes) as they are in SQL2000?

I am writing a C#.NET app that extracts data from a SDF file and I
used the Tables and Columns views to see what was in it, but the
returned fields, even though I was able to glean out what I needed,
appear to be in a different format that they are in SQL2000.

Reply to this Message

Jin - 22 Feb 2008 17:54 GMT

On Feb 22, 11:27 am, za...@construction-imaging.com wrote:

> Do the INFORMATION_SCHEMA Views in SQL Server CE have the same layout
> (columns returned and their datatypes) as they are in SQL2000?
[quoted text clipped - 3 lines]
> returned fields, even though I was able to glean out what I needed,
> appear to be in a different format that they are in SQL2000.

I wouldn't take someone words on this.
If you have access to both, then why not compare them yourself to make
sure.

- Jin

Reply to this Message

zacks@construction-imaging.com - 26 Feb 2008 19:58 GMT

> On Feb 22, 11:27 am, za...@construction-imaging.com wrote:
>
[quoted text clipped - 11 lines]
>
> - Jin

That's the problem, I do not have access to SQL Server CE. I was able
to figure out the schema of one SDF file, but I anticipate having to
do more and would like to write an application that dumps this info
out in a more formal format than picking out what I needed from
debugger output.

Reply to this Message

Jin - 26 Feb 2008 21:10 GMT

On Feb 26, 2:58 pm, za...@construction-imaging.com wrote:

> > On Feb 22, 11:27 am, za...@construction-imaging.com wrote:
>
[quoted text clipped - 17 lines]
> out in a more formal format than picking out what I needed from
> debugger output.

You can download and install SQL Server CE from Microsoft website.
You can also configure it (instructions already on this board) so that
you can access SDF database via VS 2005 and SQL Server Management
Studio Express. Also, I believe there are ways to extract schema
information without accessing the system schema tables directly. That
approach may help in avoiding the schema differences.

Reply to this Message

zacks@construction-imaging.com - 28 Feb 2008 20:52 GMT

> On Feb 26, 2:58 pm, za...@construction-imaging.com wrote:
>
[quoted text clipped - 26 lines]
> information without accessing the system schema tables directly. That
> approach may help in avoiding the schema differences.

I have installed SQL Server CE but it does not appear to install any
items on the Start menu.

Actually, I figured out an easy way to do this, just write a .NET app
that runs a select * on the views and bind the result set to a
DataGridView. Voila, the column names are displayed in the
DataGridView.

Now, I am wondering what other views other than Tables and Columns are
there? I know there is not one for Views, cuz I tried that one and got
a table not found error.

Reply to this Message

Ginny Caughey [MVP] - 28 Feb 2008 21:16 GMT

If you have Visual Studio 2005 or SQL Server 2005, you can use either tool
to manage SQL Compact 3.0 and 3.1 databases. Similarly if you have Visual
Studio 2008 or SQL Server 2008 CTP, you can use either of those tools to
manage and test querires on a SQL Compact 3.5 database.

Other INFORMATION_SCHEMA views are Indexes, Key_Column_Usage,
Table_Constraints, Provider_Types, and Referential_Constraints.

Signature

Ginny Caughey
Device Application Development MVP

www.wasteworks.com
Scalehouse and Billing Software for Waste Management

On Feb 26, 4:10 pm, Jin <jinsooch...@gmail.com> wrote:

> On Feb 26, 2:58 pm, za...@construction-imaging.com wrote:
>
[quoted text clipped - 29 lines]
> information without accessing the system schema tables directly. That
> approach may help in avoiding the schema differences.

Reply to this Message