Create MS Access Database file with C#

 

Create MS Access Database file with C#

using ADOX;

namespace WindowsFormsApplication9

{

public partial class Form1 : Form

{

public Form1()

{

InitializeComponent();

}

private void button1_Click(object sender, EventArgs e)

{

CatalogClass ct = new CatalogClass();

object a = ct.Create("Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source='C:\\pp\\People.mdb';");



}

}

}
--------------------------------------------------------------------------------
Add ADOX namespace

---------------------------------------------------------------------

By: Pankaj Sharma

Column Information of Tables in Current Database

Column Information of Tables in Current Database

select * from INFORMATION_SCHEMA.COLUMNS

By: VidyaGyan

how to select tables information from Database in MsSQL

 

select tables information from Database in Ms-SQL

Select * from information_schema.tables

  OR

SELECT * FROM sys.Tables

by: VidyaGyan