In one of my application I am getting (through OTL using ODBC drivers) the following information from the SQL Server 2005 for each table
- Column Name
- Datatype of each column
- Primary key information
and after getting this information I create a table with the same schema information in another database (through OTL using ODBC drievrs). As far as the schema and primary key constraint is concerned, these are same in both DBs (source and destination) but one information that I am unable to get from the source DB and consequently unable to create it in the destination DB is filegroup information. I am pasting the scripts of both tables
PRIMARY KEY CLUSTERED
(
[Code] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
I know that there are some minor differences in both scripts but I don't need to worry about that. The only thing I want is, that I want to get the filegroup name (in this case Students) before creating the table in the destination DB. Can anyone tell me that how can I get the filegroup information.