It's not a secret anymore!*
The moose likes JDBC and the fly likes SQL Server 2000 Create Table Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SQL Server 2000 Create Table" Watch "SQL Server 2000 Create Table" New topic

SQL Server 2000 Create Table

Yoo-Jin Lee
Ranch Hand

Joined: Nov 01, 2000
Posts: 119
Does anyone know of a system stored procedure that will return the script that created a table? Similiar to the result in 'Script to object to new window as' -> create, in SQL Query Analyzer. I know I can use DatabaseMetaData and some other system stored procedures to reproduce the original 'Create Table...' but am looking for something a little easier.
I agree. Here's the link:
subject: SQL Server 2000 Create Table
Similar Threads
java.sql.SQLException: Io exception: The Network Adapter could not establish the conn
SQL Query Problem
jsp + sql server
Passed 1z1-043
Create stored procedure in hssql