I have a VFP 7.0 database that I will be converting to SQL Server.

I have used a GetKey("TableName") function on all my primary keys to get the next key value when a new record is added.

Before I send my database through Xcase to an SQL Server for processing I need to drop all the default values for my key fields in all my tables.

Can someone give me a simple code that would do this automatically for all tables in a Database.

Also I have not worked with SQL Server much, but what do I set my primary key values to in SQL server that will have the same result as my GetKey function? GetKey always new what the next key should be.

Any help is appreciated.