How to get a list of columns using the "sys.columns" view in ms sql server?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What are relationships and mention different types of relationships in the dbms

0 Answers  


Define msdb database?

0 Answers  


If suppose in a table ship(name,year),find ship name having first and last name(i.e having space in between) ex: SAINT LOUIS,JET LAKE.

4 Answers  


How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?

1 Answers  


Explain primary key, foreign key and unique key?

0 Answers  






Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000?

3 Answers   Infosys,


What is molap and its advantage? : sql server analysis services, ssas

0 Answers  


How to turn on the mssql api module in php?

0 Answers  


Is natural join and equi join same?

0 Answers  


Can a unique index be created on a column, which contains null?

0 Answers  


Does sql server 2000 clustering support load balancing?

0 Answers  


How does recursive cte works in sql server?

0 Answers  


Categories