sql server query with joins : want to write a one single query that return table names,no of rows,table size,date table created and modified,table created by? i have 4 tables in my database.please help me out
--my database
CREATE TABLE Branch(
Br_ID int IDENTITY (1,1)PRIMARY KEY,
Name varchar(255),
Desp varchar (255)
);

CREATE TABLE Region(
R_ID int IDENTITY(1,1) PRIMARY KEY,
Name varchar(255),
Desp varchar(255)
);

CREATE TABLE Customer(
Cust_ID int IDENTITY(1,1) PRIMARY KEY,
Name varchar(255),
Desp varchar(255)
);

CREATE TABLE Customer_Branch(
Br_ID int FOREIGN KEY REFERENCES Branch(Br_ID)not null,
Cust_ID int FOREIGN KEY REFERENCES Customer(Cust_ID) not null,
PRIMARY KEY (Br_ID,Cust_ID)
);
INSERT INTO Branch (Name,Desp)
VALUES ('xyz','headoffice');