>This is exactly what I did. And the result was as I described, step by step. And I was hoping I can combine it all in a more concise statement.

Concise (readable and understandable) is what SSMS gave you. Do not try to overcomplicate SQL commands.

You can issue all the commands in a single command execution - just separate the commands with semicolons.

>Thank you
>
>>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