Get All tables Schema

To find any specific field from whole database use following query.

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE ‘%package%’

Be the first to like this post.

This entry was posted on February 16, 2010. It was filed under Database, SQL and was tagged with sql schema table database C#.

Enter your comment here...

Fill in your details below or click an icon to log in:

Email (required) (Address never made public)

Name (required)

Website

You are commenting using your WordPress.com account. ( Log Out / Change )

You are commenting using your Twitter account. ( Log Out / Change )

You are commenting using your Facebook account. ( Log Out / Change )

Connecting to %s