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

Differentiate between SQL and ORACLE joins and write their syntax.

820


What guidelines should be followed to help minimize deadlocks?

715


Issues related in upgrading SQL Server 2000 to 2005 / 2008

1707


What is the difference between drop table and truncate table?

700


What is an index. What are the types?

793


What is openxml in sql server?

916


Describe and explain about SQL native client?

844


What is a covered index?

744


What are the lambda triggers?

703


write an SQL query to list the employees who joined in the month of January?

1418


What are the steps you will take to improve the performance of a poor performing query?

800


Define self join?

823


What is compound operators?

749


Can a trigger be created on a view?

767


You are doing log shipping due to some reasons it is failing. How you will proceed from there

1808