Enable select into in sybase
To enable inserts (i.e. if you want to restore a backup with bcp) you can use sp_dboption as follows:
isql -S SERVER -U USER -PASSWORD
use master
go
sp_dboptionDATABASE, "select into", true
go
use DATABASE
go
checkpoint
go
isql -S SERVER
use master
go
sp_dboption
go
use DATABASE
go
checkpoint
go
posted by Gralfca at 9:16 AM
3 Comments:
thak you Mr
I had a problem to activate the select into option in sybase but with your blog, I've found the solution of my problem.
thank you ! !
yet, my other question is that I want to list all properties of a table field (for exemple the name, type, size, default value)
whith my script, I have got all except the defaut value.
can you help me ?
There are tools like aqua studio that can generate the sql code description from a given object. Have you tried with ddlgen ?
Post a Comment
<< Home