Skip to main content
Question Protected by Paul White
deleted 26 characters in body; edited tags; edited title
Source Link
Nick Chammas
  • 14.8k
  • 17
  • 76
  • 123

How todo I list /or search all columnsthe column names in a SQL Server 2008 Databases.my database?

I want to search whetherfor a particular column exact or likestring in the names of the columns present in a database. 

I’m working on a maintenance projectsproject and databasesome of the databases I deal with have more than 15O150 tables. I have created database diagrams based on functionality, but sometimes I wantso I'm looking for a quick way to locate tables and columns quicklydo this.

What do you recommend?

How to list / search all columns in a SQL Server 2008 Databases.

I want to search whether a particular column exact or like present in a database. I’m working on a maintenance projects and database have more than 15O tables. I have created database diagrams based on functionality, but sometimes I want to locate tables and columns quickly.

How do I list or search all the column names in my database?

I want to search for a string in the names of the columns present in a database. 

I’m working on a maintenance project and some of the databases I deal with have more than 150 tables, so I'm looking for a quick way to do this.

What do you recommend?

Tweeted twitter.com/#!/StackDBAs/status/146732169975439360
Tweeted twitter.com/#!/StackDBAs/status/25732735226089474
edited tags
Link
Sandeep Kumar M
  • 4.7k
  • 3
  • 32
  • 35
edited tags
Link
Sandeep Kumar M
  • 4.7k
  • 3
  • 32
  • 35
Source Link
Webber
  • 695
  • 1
  • 6
  • 8
Loading