Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Practical way convert generated gendbc codes to sql script
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Practical way convert generated gendbc codes to sql script
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01430179
Message ID:
01430179
Views:
124
Hi All,
i need practical solution to convert generated gendbc codes to SQL Script like Create TO codes

eg :
* GenDBC Generated VFP Codes
CREATE TABLE 'STOK.DBF' NAME 'STOK' (SKODU C(16) NOT NULL, ;
                   SADI C(25) NOT NULL, ;
                   BIRIM C(3) NOT NULL, ;
                   MYGUID C(38) default newid() NOT NULL)

*  Part of Managment Studio  ' Create TO ' Codes
CREATE TABLE [dbo].[STOK] (
				[SKODU] [nchar] (16) NOT NULL, 
                   [SADI] [nchar] (25) NULL, 
                   [BIRIM] [nchar] (3) NULL, 
                   [myguid] [uniqueidentifier] ROWGUIDCOL  NOT NULL
                   )

ALTER TABLE [dbo].[STOK] ADD  CONSTRAINT [DF_stok_myguid]  DEFAULT (newid()) FOR [myguid]
any suggestions would be very appreciated

TIA
Next
Reply
Map
View

Click here to load this message in the networking platform