title: Alter all tables in database
body: <p>I would like to run a "Alter Table" on <strong>ALL</strong> the tables in my SQL databse:</p>
  
  <pre><code>ALTER TABLE test ADD  CONSTRAINT [COLLUM_NAME]  DEFAULT ((0)) FOR [COLLUM_NAME]
  </code></pre>
  
  <p>I know how to get all of the existing tables from the database:</p>
  
  <pre><code>SELECT TABLE_NAME 
  FROM INFORMATION_SCHEMA.TABLES
  WHERE TABLE_TYPE = 'BASE TABLE'
  </code></pre>
  
  <p>or</p>
  
  <pre><code>USE DATABASE_NAME
  GO 
  SELECT name
  FROM sys.Tables
  GO
  </code></pre>
  
  <p>But I don’t know how to combine these two.</p>
  
  <p>In my database (50+ tables) all of the tables have 1 row in common.
  and I would like to set a default value to all of these rows.</p>