Re: INFORMATION_SCHEMA Views in SQLServer CE

Tech-Archive recommends: Fix windows errors by optimizing your registry

On Feb 26, 4:10 pm, Jin <jinsooch...@xxxxxxxxx> wrote:
On Feb 26, 2:58 pm, za...@xxxxxxxxxxxxxxxxxxxxxxxx wrote:





On Feb 22, 12:54 pm, Jin <jinsooch...@xxxxxxxxx> wrote:

On Feb 22, 11:27 am, za...@xxxxxxxxxxxxxxxxxxxxxxxx wrote:

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.

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

- 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.

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.

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.
.

Relevant Pages

  • Re: multiple cascade paths
    ... You should not have them if your schema is designed properly. ... make you understand that I tried to show that a proper design can have ... am a SQL Server MVP, for crying out loud - you can safely assume that I ...
    (comp.databases.ms-sqlserver)
  • Re: Need help on how to organize users and objects
    ... Yes Oracle is a bit different than Sql Server, but I think you will get the ... It doesnt become part of any schema until you assign it. ... a new developer started to work. ... need the COMMON database which stores tables with generic data and generic ...
    (microsoft.public.sqlserver.security)
  • Re: 3 Simple Security SQL Statements
    ... In SQL 2005, when you create an object, you specify the schema that the ... Kalen Delaney, SQL Server MVP ... Schema for a database role, that seems like the best setup. ... EXEC sp_addrolemember 'WebUsersRole', 'WebUser' ...
    (microsoft.public.sqlserver.security)
  • Re: same application on multiple schemas
    ... As for the "comparison" with Sql Server, it was not intended to ask ... why Oracle does "not" support sql server behaviour:) I know oracle (I ... For every customer that will use our application, ... will use schema "SchemaA" ...
    (comp.databases.oracle.server)
  • Re: Model Driven Architecture, bussiness rules in DB?
    ... authorization schema. ... neither does SQL Server. ... For instance when you grant access to a table you should be able ... accessing applications? ...
    (comp.databases.ingres)