Friday, June 8, 2012

Today I found a solution to check a column existing in the table or not :)

In SQL Server:

 SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'MyTableName' AND COLUMN_NAME = 'MyColumnName'


In Oracle:

SELECT * FROM user_tab_columns
WHERE table_name = '<tablename>'
AND column_name = '<columnname>

No comments:

Post a Comment