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

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

Question Posted / sathish

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

Please Help Members By Posting Answers For Below Questions

what is a traditional network library for sql servers? : Sql server database administration

951

Different types of keys in SQL?

1097

How to create a dynamic cursor with the dynamic option?

1045

Can we call stored procedure in trigger?

950

Do you know what are acid properties of transaction?

953

How to drop an existing schema in ms sql server?

1100

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

1000

Suggest a method of joining two tables.

1155

What is the size of transaction log file?

931

What is the federation in sql azure?

How can we solve concurrency problems?

1054

What are the drawbacks of reporting in ssrs?

149

Why do we use functions?

913

What do you understand by triggers?

922

What is truncate table?

938