Blog Archives

SQL Server List Tables And Columns

–List Column Names SELECT COLUMN_NAME, TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_CATALOG = ‘YOUR_DB_NAME’ –List Tables SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_CATALOG = ‘YOUR_DB_NAME’ –List Views SELECT * FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_CATALOG = ‘YOUR_DB_NAME’ –List All Columns in All Views SELECT *

Tagged with: , , , , ,
Posted in SQL Server

Dynamically Populate a DataGridView Using Enterprise Library With Values From a Selected Table in SQL Server

Dynamically Populate a DataGridView Using Enterprise Library With Values From a Selected Table in SQL Server This is a quick way to give a user the ability raw look at the data contained in tables in the database linked to

Tagged with: , , , , ,
Posted in Visual Studio Code Examples