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

Answer Posted / erwin suryana

sp_columns <table_name>

Is This Answer Correct ?    5 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between temp table and cte?

527


How do I partition a table in sql server?

531


Why do we need normalization?

484


What is raid, and how it can influence database performance?

568


Describe the functionalities that views support.

648






What is delete query?

517


what is datawarehouse?

644


How ssrs maintain security?

572


Which language is supported by sql server?

550


Define the one-to-one relationship while designing tables.

505


Does index slows down insert statements?

581


What is difference between cte and view?

519


Why use “pivot” in sql server?

614


What will happen if a column containing char type data is changed to the nchar data type?

615


How to check status of stored procedure in sql server?

439