>By the way, do you think I should leave all the "[dbo]" in the string I will be sending to the SQL Server? Or it is ok to remove them?
>
You can (it's just a schema designator). It doesn't hurt to have it though.
>>
>>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
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________