I do it this way....
Go into SSMS and create everything the way I want it (tables. index, etc)
Right-click on the table (or database) select "Script Table As...".
Select the script type and destination
>Hi,
>
>I am making a script for creating a new table (this script will be sent from VFP to the SQL Server). For starters I created the script in the SSMS. When SSMS creates the script it does it in several stages:
>1. Creates table; e.g.
>
>create table [dbo].[MyTable] (
> [fld1] [Int] Identity (1,1) not null,
> [fld2] [char] (20 not null...
>and so on
>
>2.Create nonclustered index;e.g.
>
>CREATE NONCLUSTERED INDEX [IX_fld2] ON [dbo].[MyTable]
>(
> [fld1] ASC
>and so on
>
>3. Create another nonclustered index (simimal to step 2 above)
>4. Then next one and next one
>5. Set default contraints for each field; e.g.
>
>alter table [dbo].[mytable] and constraint [df_fld2] default ('') for [fld2]
>and so on for each field
>
>
>My question is, can I do it all, creating structure, creating indexes, default constraints, in only statement? TIA
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer