I am writing a program in Visual Basic, and I need to run some kind of
a script via ODBC. I want SQLServer to tell me the table structure.
Can this be done?
I basically want returned the script which you can run in Enterprise
Manager. I will be using the returned data to build a Create Table
clause. I will not know the table structure before hand, so I need
something SQLServer to return something like:
CREATE TABLE Customer (
CustID varchar (255) NOT NULL ,
FName varchar (40) NOT NULL ,
MName varchar (40) NULL ,
LName varchar (40) NOT NULL ,
Title varchar (5) NOT NULL ,
Email varchar (30) NULL ,
Address varchar (255) NOT NULL
Thanks in advance for any help!!