Add a column to an existing table


 if not exists (select 1 from INFORMATION_SCHEMA.columns
 where table_schema = 'dat'
   and table_name = 'table_name'
   and column_name = 'your_column')   
 begin
     alter table dat.table_name
     add your_column varchar(255)
 end

Add comment

biuquote
  • Comment
  • Preview
Loading

Sponsored by

Calendar

<<  February 2018  >>
MoTuWeThFrSaSu
2930311234
567891011
12131415161718
19202122232425
2627281234
567891011

View posts in large calendar

RecentComments

TextBox