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
Differentiate between SQL and ORACLE joins and write their syntax.
What guidelines should be followed to help minimize deadlocks?
Issues related in upgrading SQL Server 2000 to 2005 / 2008
What is the difference between drop table and truncate table?
What is an index. What are the types?
What is openxml in sql server?
Describe and explain about SQL native client?
What is a covered index?
What are the lambda triggers?
write an SQL query to list the employees who joined in the month of January?
What are the steps you will take to improve the performance of a poor performing query?
Define self join?
What is compound operators?
Can a trigger be created on a view?
You are doing log shipping due to some reasons it is failing. How you will proceed from there