In SQL Server:
SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'MyTableName' AND COLUMN_NAME = 'MyColumnName'
In Oracle:
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