How to check for any particular column name exists in which table of database in Sql Server ~ Coderskey

Monday, 3 December 2012

10:22

Anonymous

Using below written query we can get the name of the tables, in which passed column name is present/exist in database:

SELECT TABLE_SCHEMA + '.' + TABLE_NAME AS NameOfTables
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME = 'MyColumnName'

Here,

MyColumnName = Name of the column which you want to find, that in which table it exists.

Enjoyyy.....

Unknown said...: i think it is also work

select table_name,column_name from information_schema.columns
where column_name like '%tax%'; 25 February 2013 at 20:04
Unknown said...: i want know about the Query when we forget the password of admin how to rest new password?; 25 February 2013 at 20:06
Abhinav Ranjan Sinha said...: @manoj: HI you can use like this:

Update loginTableName SET password='NewPass' Where username='UserName'

Note: on the place of :
loginTableName : use your table name in which you have username and password saved, then
NewPass: Use the new password which you want to set.
UserName: Use the username of Admin which you use for login.

Here,
password and username are column names change accordingly with your column names in database table.

Thanks; 26 February 2013 at 00:50