skip to main
|
skip to sidebar
My Tech Blog
Tuesday, May 6, 2008
check if a column exists using sqlserver metadata
if exists ( select * from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME='PTGatewayInBreak' and COLUMN_NAME='Foo' )
alter table PTGatewayInBreak drop column foo
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Current goals
jquery
javascript
rubyrails
Labels
bad
caching
classpath
convetion
cucumber
cygwin
design
django
eclipse
ejb
exceptions
filter
geo
git
gwt
gwtt
idioms
ie
integration
issue
ivy
java
javascript
jaxb
jboss
jbosscache
jdbc
jee
junit
linking
linux
maps work
mouse
mvc
netbeans
organise
os
performance
programming
python
rails
regex
rmi
rspec
ruby
rubyrails
security
sicp
software
sqlserver
syntax
testing
todo
transactions
uglycode
vim
web
wifi
ws
Blog Archive
►
2010
(4)
►
August
(1)
►
July
(1)
►
April
(1)
►
February
(1)
►
2009
(37)
►
August
(2)
►
June
(3)
►
May
(4)
►
April
(4)
►
March
(8)
►
February
(10)
►
January
(6)
▼
2008
(29)
►
December
(4)
►
November
(5)
►
October
(1)
►
September
(2)
►
June
(1)
▼
May
(1)
check if a column exists using sqlserver metadata
►
April
(6)
►
March
(3)
►
January
(6)
►
2007
(22)
►
December
(2)
►
November
(2)
►
October
(2)
►
September
(7)
►
August
(8)
►
July
(1)
No comments:
Post a Comment