Finding a Column in Database Table

[pawanez4u]

Hi Every one,

I want to find whether a particular column in a SQL database table exists or not which the "column name".

Kindly help me with the appropriate.

Thanks in Advance.

Regards
Pavankumar P

[Torgg]

Since you did not state what language you were using I'll skip the code samples. I found this link and it gives you a SELECT statement that returns all the column names. I would use the SELECT statement to populate a datatable and then I would search the datatable for the Column Name you want. You could also modify the query to select only the column name and table you are looking for, if it returns nothing then the column was not found.

http://www.thescripts.com/forum/thread271784.html

SELECT
COLUMN_NAME,
DATA_TYPE,
CHARACTER_MAXIMUM_LENGTH
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'Customers'

OR

SELECT
COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME = 'YourColumnName' AND TABLE_NAME = 'Customers'

I hope this was helpfull,
Torgg

[r035198x]

Since you did not state what language you were using I'll skip the code samples. I found this link and it gives you a SELECT statement that returns all the column names. I would use the SELECT statement to populate a datatable and then I would search the datatable for the Column Name you want. You could also modify the query to select only the column name and table you are looking for, if it returns nothing then the column was not found.

http://www.thescripts.com/forum/thread271784.html

SELECT
COLUMN_NAME,
DATA_TYPE,
CHARACTER_MAXIMUM_LENGTH
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'Customers'

OR

SELECT
COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME = 'YourColumnName' AND TABLE_NAME = 'Customers'

I hope this was helpfull,
Torgg

That would work for the MySQL database. It would also help if the OP specified which database they were using.