Click here to Skip to main content
16,005,389 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hii,

How can we Take Table Scripts from database in Sybase.

thank you in advance.
Posted

1 solution

Good question,

And here's a partial solution ...
SELECT [object_id], [name], [column_id] FROM sys.columns WHERE [object_id] > 99 ORDER BY [name]

Other candidates in the field category, to be used for table reconstruction, less likely to be known by the "scriptor" (you, the database copier):
[system_type_id]
[user_type_id]
[max_length]
[precision]
[scale]
[collation_name]
[is ................ (etc)]

[xml_collection_id]
[default_object_id]
[rule_object_id]

The point being that the programmer will have to reconstruct the tables using some TSQL:
CREATE TABLE ....

Based upon his knowledge of the Sybase instance.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900