how to Create scripts with sql 2005 to create table and fields and also to add fields to existing tables ....

create table PutSomeTableNameHere ( field1  varchar(100), filed2 int, field3  bit)

in order to alter the existing tables use


ALTER TABLE putTableName
ADD someOtherColumn  int

This to to create table..but hoew to generate script of this so that my client can run on his machine to create tables in his database....

with SQL Server, you can open Enterprise Manager, drill down to the Table level, the Right Click on each table, and choose Generate SQL Script - this will generate the necessary SQL to create the Table Schema, when executed on as New SQL Server instance.

Is that what you are after?

AW

be right back.....