IF (SELECT count(*) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'TableName' AND COLUMN_NAME='columnName')>0
BEGIN
alter table Event ADD StoreAmount [int] NOT NULL DEFAULT 0
END
Subscribe to:
Post Comments (Atom)
It's my space
Posts
1 comment:
Oracle 的找法
SELECT * FROM dba_tab_columns where column_name like 'BILL%TYPE';
Post a Comment