Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / Jagesh Kumar
To list all the columns in a SQL Server database, you can use the INFORMATION_SCHEMA.COLUMNS view:nn```sqlnSELECT TABLE_NAME, COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS;n```
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why and when do stored procedure recompile?
List out the different types of locks available in sql server?
Why use identity in sql server?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What is sql server query analyzer?
What is standby servers? Explain types of standby servers.
Explain “row_number()” in sql server with an example?
How to rebuild the master database?
When should you use an instead of trigger?
do you know how to configure db2 side of the application? : Sql server database administration
How to connect php with different port numbers?
What kind of problems occurs if we do not implement proper locking strategy?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
How can I check that whether automatic statistic update is enabled or not?
How to enter binary string literals in ms sql server?
