Skip to main content

Query to retrieve a list of tables from MS SQL SERVER CE (*.sdf) database

A very simple statement can accomplish the task of finding a list of all tables in a MS SQL Server CE (*.sdf) database :

The query is given below:

SELECT  table_name FROM  information_schema.tables WHERE(TABLE_TYPE <> 'VIEW')

You may use SQLCommand class to execute this sql command.

Thanks  
Labels:

Comments

Post a Comment

Popular posts from this blog

FTP(File Transfer Protocol ) configuration and testing in Windows Server 2008 R2

First of all you have to know  what the FTP is " File Transfer Protocol ( FTP ) is a standard network protocol used to transfer files from one host or to another host over a TCP -based network". FTP Installation & Configuration: Step 1: Install the Web Server role with the IIS Management Console and FTP Server role services: Step 2: Add a new FTP Site Step 3: Setup the site with the default bindings and choose Allow SSL to avoid deploying a certificate:     Step 4: Configure user permissions and basic or anonymous permission. If your server is connected to your domain you can specify domain users, otherwise they must be local user accounts: Note: Finally you’ll have to configure your server’s firewall rules to allow access.Disregard any existing FTP firewall rules; although they should be enabled, they don’t actually allow access! Run Allow a Program Through Windows Firewall and grant access to C:\Windows\System32\svchost.exe T...
Post a Comment
Read more

Download Image from URL using HTTPClient in C#

 async Task<string> GetAndSaveImageAsync(string url)         {             string imageName = $"{Guid.NewGuid()}.png";             string filePath = System.IO.Path.Combine(_webHostEnvironment.ContentRootPath, "Resources","Images");             if (!Directory.Exists(filePath))             {                 Directory.CreateDirectory(filePath);             }             var httpRequest = new HttpRequestMessage(HttpMethod.Get, url);             using (var httpClient = new HttpClient())             {                 var response = httpClient.SendAsync(httpRequest).Result;                 if (response.StatusC...
Post a Comment
Read more