What is the equivalent of 'describe table' in SQL Server??

I have a SQL Server database and I want to know what columns and types it has. I'd prefer to do this through a query...

What is the equivalent of 'describe table' in SQL Server??

I have a SQL Server database and I want to know what columns and types it has. I'd prefer to do this through a query...

in sql connecting transaction table with different kinds of transactions?

I am making a mysql database for a restaurant. I have a table called: *tbl_contents* which stores all the contents ...

Hotel Management Database Design Problems?

I am trying to get started with Web Development by trying to develop a Hotel Management System. I am using MySQL 5....

How to query MongoDB with “like”??

I want to query something with SQL's like query: SELECT * FROM users WHERE name LIKE '%m%' How to do I achieve t...

white circle in microsoft SQL server management studio 2012?

I'm new in SQL server management studio 2012 now i'm use data from server and it has a white circle on my database ...

Getting white icon for instance in SSMS??

I have registered one new server but showing white icon instead of green. But my other colleagues can able to see gr...

Recipe database design advice?

I have a problem designing my database. I have to make a table witch contains let's say a Recipe. I have tables that...

How to structure a database with multiple join tables?

This is the first time I'm trying to store a more complex object into a database. I need some help with the design o...

Oracle NVL equivalent in SAS?

I need to convert the sql code to sas code; NVL(SPRTELE_STATUS_IND, 'A') = 'A' AND NVL(SPRTELE_PRIMARY_IND, 'Y...

Database structure for “customer” table having many orders per customer and many items per order?

I am trying to create a database where each customer has several orders(new orders daily) and each order has several...

How are these tables related??

Say I run an online business where you can order products from my website, and I have a database with two tables: T...

Data modelling draft/quote/order/invoice?

Im currently working on a small project in which I need to model the following scenario: Scenario Customer calls,...

Database Design for Invoices With Monthly Installments?

This question is an extension/expansion of an already answered question on StackOverflow: Database Design for Invoic...