vj_mi
asked on
System SP to view table structure
Just like we use sp_helptext from Query analyzer to view SP details, which SP will allow me to view table structure from SQL Query Analyzer?
Regards,
MI
Regards,
MI
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
sp_helptable 'tablename'
you can also use the following query:
select * from information_schema.columns where tablename = 'table name'
select * from information_schema.columns
Also you can use ,
Sp_help 'tablename'
Sp_help 'tablename'
ASKER
sp_helptable 'tablename' and select * from information_schema.columns where tablename = 'table name' gave me error. But sp_columns 'tablename' and Sp_help 'tablename' worked.