columns names,datatypes,length and indexes ! 
Author Message
 columns names,datatypes,length and indexes !
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 ?

Barak Mery



Fri, 18 Jul 2003 04:16:35 GMT
 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 ?

Barak Mery



Sat, 19 Jul 2003 08:10:13 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Display Column Names, Column Data Types and Lengths

2. Non-nullable columns without knowing datatype/length...

3. HELP: Finding index names in sysindexes using a column name

4. Getting the Index names and indexed columns for a schema

5. SQL to :- index name if column has index ?

6. Max Column Name Length

7. Maximum table/column name lengths

8. Column Name Length

9. Weblogics/DB2/length index names

10. Column name length limit

11. Maximum column name length

12. Column name length?


 
Powered by phpBB® Forum Software