![]() ![]() With these few simple scripts, a user is fairly equipped to look up the tables in a database that contains a particular column name. It cannot be seen in the screenshot below, but the query returned 744 rows in total: If the condition is to find exact matches, lose both the Like operator and the percent signs and use the equal operator in the Where clause like shown below: As can be seen above, the results for the search phrase “address” will also return “Address” records. The search term that is specified is not case sensitive. This simple query returns all column names that have string “address” in their names: In this particular case, the targeted database is set to AdventureWorks2014, and the column name is telling the SQL Server to look for all possible beginnings and endings to that “address” root.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |