http://snippets.dzone.com/posts Fri, 25 Jul 2008 05:16:51 GMT DZone Snippets: schema code http://snippets.dzone.com/posts/show/4664 // Select database schema. <br />//This could be used to recreate or test for existence of columns/tables <br />//or could also be used to create a database template system to enable the writing //of database schema into txt template file to be recreated again by reading the //txt file via an application <br />// <br />//You can also use SELECT * instead of defining each schema property (column) <br /> <br /><code> <br />SELECT TABLE_CATALOG <br />, TABLE_SCHEMA <br />, TABLE_NAME <br />, ORDINAL_POSITION <br />, COLUMN_DEFAULT <br />, IS_NULLABLE <br />, DATA_TYPE <br />, CHARACTER_MAXIMUM_LENGTH <br />, COLLATION_NAME <br />FROM <br />INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = (N'Persons') <br /></code> Wed, 17 Oct 2007 11:30:21 GMT http://snippets.dzone.com/posts/show/4664 dubby (Dave)