Any one know if it possible to create SQL Server script to return information on any field in the Table; ie Field Name, var type for example int, nvarchar, etc. Also the variable size.
- for example Table1 has Field A is nvarchar and size 50 chars, should returns
Field Name = 'Field A'
Var type - nvarchar
and size - 50

If you can help, I would be greatful... thanks in advance

Regards
Kasie. :)

Look in BOL at the INFORMATION_SCHEMA.COLUMNS view.

You can also get what you are looking for from the 'sp_columns' system stored procedure, although the view is a bit more flexible since you can SELECT only the information you need from it.

Either of these methods is preferable to querying the 'syscolumns' system table directly (which of course also works), IMO.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com