Answer Posted / harshad

select count(*) from information.schema.columns
where table_name='tablename'

//where tablename is name of your sql table.
//do not prefix table name with .dbo

Is it possible to replicate data from sql server to oracle? : sql server replication

1034

---

Is truncate a dml command?

889

---

How do I view a stored procedure in sql server query?

886

---

Where sql server usernames and passwords are stored in a sql server?

933

---

What is trigger explain with program?

931

---

How can a user-defined datatype be created?

935

---

How to list all user defined functions in the current database?

975

---

What are the properties of primary key?

913

---

State a few properties of relational databases?

1060

---

What are 3 ways to get a count of the number of records in a table?

1017

---

Explain what is the difference between a local and a global temporary table?

936

---

How to create user messages with print statements in ms sql server?

940

---

What are commit and rollback in sql?

1052

---

Which language is supported by sql server?

954

---

How to throw custom exception in Stored Procedure?

992

---