#information_schema.columns

[thedbahub]

Checking for the Existence of a Column in a SQL Server Table

To check if a column exists in a SQL Server table, you can use the INFORMATION_SCHEMA.COLUMNS system view, which provides information about all columns in all tables in a database. Here’s a SQL query that checks if a specific column exists in a specific table: IF EXISTS ( SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'YourTableName' AND COLUMN_NAME = 'YourColumnName' ) BEGIN PRINT…

View On WordPress

[jjw448-blog]

mysql 테이블정보

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE 1=1 AND TABLE_SCHEMA = 'DB명' AND TABLE_NAME = 'TABLE명' ORDER BY ORDINAL_POSITION ASC