Schema.ini File 
Author Message
 Schema.ini File
Is there any way to take a current SQL table structure
(either 7.0 or 2000) and save it's details as a schema.ini?

Thank you!



Wed, 01 Jun 2005 00:32:01 GMT
 Schema.ini File

There is no built-in tools for this. You have to create it yourself. You
could query against Information_Schema.* views for desired schema.

--
-oj
http://www.rac4sql.net


Quote:
> Is there any way to take a current SQL table structure
> (either 7.0 or 2000) and save it's details as a schema.ini?

> Thank you!



Wed, 01 Jun 2005 01:10:48 GMT
 Schema.ini File
You can script them and save them as whatever you like.

--
- Anith
(Please respond only to newsgroups)



Wed, 01 Jun 2005 01:08:54 GMT
 Schema.ini File
What exactly is a schema.ini?   You can certainly script the objects and
place them in a text file.

--
Andrew J. Kelly
SQL Server MVP


Quote:
> Is there any way to take a current SQL table structure
> (either 7.0 or 2000) and save it's details as a schema.ini?

> Thank you!



Wed, 01 Jun 2005 01:10:08 GMT
 Schema.ini File
Heidi ,
Have a look at the output of SQL Scribe Documentation Builder.  The MDB
files contains the scripts of all object in the database.

http://www.ag-software.com/ags_scribe_index.asp
--
I hope this helps
regards
Greg O MCSD
Document any SQL server database
AGS SQL Scribe http://www.ag-software.com/ags_scribe_index.asp


Quote:
> Is there any way to take a current SQL table structure
> (either 7.0 or 2000) and save it's details as a schema.ini?

> Thank you!



Wed, 01 Jun 2005 21:02:06 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. How to ignore a column in Schema.ini file

2. Help! with Schema.ini file and ODBC text

3. Help -- Schema.Ini file format

4. Where to put the Schema.ini File

5. Schema.ini file date formats

6. schema.ini file location

7. schema.ini and multiple files

8. SCHEMA.INI Must I use this file name???

9. Text File Databases/Schema.ini Limitation

10. Exporting to ASCII File with SCHEMA.INI?

11. Schema.ini With Adhoc ODBC Text File Connections

12. ADO, Text Files and that damned Schema.ini


 
Powered by phpBB® Forum Software