Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How to get only the schema of the database into a dataset?

Tags:

c#

.net

ado.net

dataset

How to load only the schema of the tables into a dataset.

like image 725
Malik Daud Ahmad Khokhar Avatar asked Oct 27 '08 12:10

Malik Daud Ahmad Khokhar

2 Answers

SqlDataAdapter.FillSchema

like image 196
OJ. Avatar answered Sep 19 '22 12:09

OJ.

Do a query that normaly would return your data and add a where clause so that no rows are returned.

like image 20
idstam Avatar answered Sep 19 '22 12:09

idstam

Sign in to Comment

Related questions

Increase F# map insertion performance
ASP.NET Core in a Worker Service doesn't call Configure IApplicationBuilder
How do I change the Swagger default URL and use a custom one?
How to reference a deconstructed value tuple without making a copy of it
Click Button in Toolbar of Other Program
How to extend an ASP.NET Core MVC project by Razor Pages?
Publish ASP.NET Core MVC website to IONOS 1&1 via Visual Studio FTP
C# 9 Nullable types issues
How to Separate IObservable and IObserver
Creating a logical folder structure when creating a 7-Zip archive via the command-line
Is MediatR library overused in CQRS examples on the web?
Why does StartsWith return the wrong value only on my machine? [duplicate]
How do you prevent leading zeros from being stripped when importing an excel doc using c#
Listview Multiple Selection
WCF faults and exceptions
Implementing multithreading in C# (code review)
New site creation and security/authentication,- should I use ASP.net Membership Provider?
How do I see the hex values of a string in a VS2008 watch window?
How can I programmatically determine whether an MP3 file is CBR or VBR? (preferrably using c#)
Is there a string table resource for Visual C# 2005?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!