SQL Server

1.一个一个TABLE去点,汇出Scripts

2.SQL Server 汇出script (可选取多个table,一次汇出
资料库右键/Tasks/Generate Scripts

SELECT  distinct top 1 TABLE_NAME,'select top 1 * into test.'+TABLE_NAME + ' from '+TABLE_SCHEMA+'.'+	 TABLE_NAME 
FROM icrm.INFORMATION_SCHEMA.COLUMNS 
ORDER BY TABLE_NAME

Sybase

1.一个一个去点table汇出script
2.

 select  distinct 'select top 1 * into ooo.'+tname+' from  '+creator+'.'+tname    +' commit;' 
 from  sys.syscolumns  where creator='xxx'
 
 select  distinct 'truncate table '+creator+'.'+tname    +' commit;' 
 from  sys.syscolumns  where creator='ooo'