Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to create an index with create table
Message
From
12/03/2014 08:46:30
 
 
To
12/03/2014 08:25:39
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01596225
Message ID:
01596269
Views:
37
>>>The table needs to be part of an DBC if you needt this syntax, for what I remember.
>>
>>it is part of a dbc
>>
>>but i cant find a way to create a regular index with the sql create table command
>>I guess I have to issue a index on ... tag ... after the create
>>
>
>Correct, you can create primary keys, candidate keys, and foreign keys in CREATE TABLE. Other tags have to be added afterward.
>
>Tamar
thanks Tamar
Peter Cortiel
Previous
Reply
Map
View

Click here to load this message in the networking platform