how can i view structure of table in sql server? tell me
that query.

Answer Posted / sathish

how can i view structure of table in sql server? tell me
that query.

Select * from information_schema.columns where table_name =
xyz

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the rdl file?

96


What is a unique index?

605


What is Federation Root Database?

92


What do you mean by a Composite primary key?

673


What happens if you delete a table that is used by a view?

661






What is the difference between char and varchar2 datatype in sql?

635


Does a sql server 2005 select statement require a from?

696


explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

713


Why and when do stored procedure recompile?

629


What is the downside of using udf?

656


What are different types of constraints?

606


In what three ways is the return statement used in a stored procedure?

605


What is the difference between cube operator and rollup operator? : SQL Server Architecture

703


How to compare the top two records using sql?

860


How to insert multiple rows with one insert statement in ms sql server?

678