I need to get with one recordset data for an object(user table). The data i need is : Col(column)name,Col datatype, Col length, Col indexes (PK,FK). Does anybody can help me ?
Barak Mery
Fri, 18 Jul 2003 04:16:35 GMT
Don Arsenaul #2 / 2
columns names,datatypes,length and indexes !
Use the catalog stored procedure sp_columns or the schema view INFORMATION_SCHEMA.COLUMNS. Check Books Online.
Don.
Hi !
I need to get with one recordset data for an object(user table). The data i need is : Col(column)name,Col datatype, Col length, Col indexes (PK,FK). Does anybody can help me ?
columns names,datatypes,length and indexes !